SQLtoXLS
Pull Data to Excel
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.
SQLtoXLS
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.
| HOW | Image, Purchase |
| WHAT | Actuals, Budgeting, Financials, Resourcing |
| WHEN | Since 2012 |
| WHERE | Companies, Custom Data, Expenses, Hours, Issues, Other, Portfolios, Programs, Projects, Roles, Tasks, Users |
| WHO | Planner, SysAdmin |
| WHY | Automation, Data Processing, Schedulable |
- Solution
SQLtoXLS
- Use the slider above to learn about this Solution's functionality
- Review the More Details section below to understand how to use it
- Consider the Pricing section and its value to you (noting payment comes later)
- When you are ready to proceed, click the button above
MORE DETAILS…
TopOur 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
PRICING
TopFrom $4,999/Domain (one time fee)
Other Actuals Solutions…
Actuals solutions include dates, costs, and/or hours, and help you assess where things are really at, relative to your plans
Top
AFA Burn Check
Prepare to
Manage Margins - Related Products
