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
AFA Burn List
Manage High
Level Margins
AFA Burn Report with Baselineᐩ
Manage
Detailed Margins
Baselineᐩ
Enrich Margin Data
Budget Vs Actual
Manage Budgets by Year
Budget Vs Actual Quarterly Burn
Manage Budgets by Quarter
Capacity Charts
Assess and
Control Resourcing
Capital Tracking
Guide Investment
Editorial Calendar
Visualize Assets
Enterprise Stopwatch
Track Time
Estimate/Invoice
Consolidate Plans
Excel Updater
Manipulate Data
Executive Status Report
Convey
the Real Story
Extract Document Text
Enhance Searches
Force Timeline Recalculation
Bolster Confidence
JITR
Apply Just In Time Resourcing
Magic Reports
Define
Custom Reports
Multi Baseline Report
Assess
Baseline Drift
Recalc Helper
Refresh Key Data
Recalc Parameters
Improve
Data Quality
Roadmap
Configure Advanced Corporate Reporting
Scheduled Excel Updater
Organize Data Pulls
SQLtoXLS
Pull Data to Excel
Swimlane ADVANCED
Draw the Big Picture Your Way
UberCalc
Define Workflows
UberTimesheet
Simplify
Time TrackingRelated Products
Scheduled Excel Updater
Our Scheduled Excel Updater solution offers you a straightforward approach to periodically load data into Workfront by automatically submitting files to our Excel Updater solution at a cadence you choose.
HOW Image, Purchase WHAT Actuals, Budgeting, Financials WHEN Since 2014 WHERE Companies, Custom Data, Expenses, Hours, Issues, Portfolios, Programs, Projects, Tasks, Users WHO Planner, SysAdmin WHY Automation, Data Processing, Schedulable, Simplification 
Excel Updater
Our Excel Updater solution affords you a cost-effective path to integrate data into Workfront without having to learn the API, write code, or set up a server, and is ideal for both one time and reoccurring data loads.
HOW Annual License, Image, On Demand, Video WHAT Actuals, Budgeting, Configuration, Financials WHEN Since 2011 WHERE Companies, Custom Data, Expenses, Hours, Issues, Portfolios, Programs, Projects, Tasks, Users WHO Planner, SysAdmin WHY Data Processing, Schedulable, Simplification
