Our SQLtoXLS solution equips you to extract data from your SQL based legacy business systems into Excel on a scheduled basis so they can then be sent to Workfront using our Scheduled Excel Updater solution.

HOWImage, Purchase
WHATActuals, Budgeting, Financials, Resourcing
WHENSince 2012
WHERECompanies, Custom Data, Expenses, Hours, Issues, Other, Portfolios, Programs, Projects, Roles, Tasks, Users
WHOPlanner, SysAdmin
WHYAutomation, Data Processing, Schedulable

  1. Solution

    TIP: We invite you to learn about this solution below, and once you are ready, to then proceed here.

    Our SQLToXLS solution equips you to extract data from your SQL based legacy business systems into Excel on a scheduled basis so they can then be sent to Workfront using our Scheduled Excel Updater solution.

    To use it…

    Most often, our customers use SQLtoXLS in conjunction with our Scheduled Excel Updater solution, although (given its unlimited use) you are welcome to employ it for any other purposes you require. Eithe way, SQLtoXLS:

    • Connects to any common databases (Oracle, SQL Server, MySQL, etc)
    • Can be maintained by your Database Administrators using a simple text editor
    • Can be called from Windows Task Scheduler on whatever cadence you require
    • When run, reads a text configuration file that specifies connection strings, SQL queries, output filename(s), spreadsheet tab names and column headings
    • Can contain one or more connection string (each query being associated with a particular connection string)
    • Generates one or more spreadsheets, with multiple tabs in each spreadsheet, and (optionally) multiple query results on tab into the output filename(s), ready for use
  2. Media

    SQLtoXLS Glossy:

  3. Pricing

    From $4,999/Domain (one time fee)

  4. Related Files
  5. Related Products