The Polychrome ODBC Export Tool exports data from any ODBC data source but that’s not all. It does a whole lot more, like emailing the results or calling a command line application and passing the exported data filename. Now you can create CSV extracts from your software and because it can be run from the command line it can be scheduled using the Windows scheduler or if you want more control (like run on last working day of the month) then use our scheduler.

Key features

• Scheduled export of data using ODBC
• Export “real world” data scenario, only orders added since last export
• Run post export process for example transfer via FTP using uFTP tool
• 2 styles of output
  • Normal exports each row on a new line
  • Header exports one header line followed by multiple detail lines
• Email extracted data to someone
• Scheduled export on special accounting days, like last working day of the month, last physical day of the month

The ODBC export tool uses SQL statements saved in a preformatted external XML file. The user interface makes creating these ODBC definitions  easy. The tool will read the data using ODBC and create a CSV file with each column separated with a comma (or your chosen delimiter) and laid out in the order determined by the SQL statement.

See the ODBC Export website http://odbcexport.com/products/automate-odbc-export/