Challenge

Extract data from your legacy business systems into a format that can easily be imported into Workfront.

Solution

SQLtoXLS is a tool that performs SQL queries against your legacy business systems, and stores the query results into Excel files. The contents of these files can be imported into your Workfront environment using the AtAppStore Excel Updater.

SQLtoXLS is one of the components offered by AtAppStore to help Workfront customers achieve cost effective integrations of Workfront with their existing systems (see our Workfront Integrations page). Most often, our customers use SQLtoXLS in conjunction with AtAppStore’s Scheduled Excel Updater.

Features of SQLtoXLS:

  • Connect to any common databases (Oracle, SQL Server, MySQL, etc) via connection string
  • Uses configuration file to drive output
  • Contains SQL queries in configuration file
  • Maintainable by DBA’s with a text editor
  • Schedulable

Frequently Asked Questions

Q: How do I configure the SQL queries that SQLtoXLS performs?
A: When SQLtoXLS runs, it reads a text configuration file. This file specifies connection strings, queries, output filename(s), spreadsheet tab names and column headings.

Q: Can SQLtoXLS generate multiple spreadsheets?
A: Yes.

Q: Can SQLtoXLS generate multiple tabs within a spreadsheet?
A: Yes.

Q: Can SQLtoXLS put multiple query results onto the same spreadsheet tab?
A: Yes.

Q: Can SQLtoXLS connect to multiple datasources?
A: Yes. The configuration file can contain one or more connection strings. Each query is associated with a particular connection string.

Q: How do I configure SQLtoXLS to be the scheduled?
A: The easiest way is to use Windows Task Scheduler to run SQLtoXLS on whatever schedule your organization requires. There are numerous other commercial and free alternatives available that could be used instead.

Q: What operating systems are supported?
A: Microsoft Windows 7, Server 2008, Server 2008 R2. Requires .Net 3.5 or newer.

Screenshots

SQLtoXLS is a console-based application. There are no screenshots.

Pricing

  • Contact us for details.

Related Products

Scheduled Excel Updater

My business data is in spreadsheets, and I need to get it into Workfront.