Database Extractor Standard/Pro versions (Major Update Pro Version Oct 2007)

Place Order    Email Support

This DataBase utility was engineered with automation and simplicity in mind. In this demanding business world ever rapidly changing, requires us to constantly upgrade and optimise infrastructure. This ultimately leads to the need to migrate information(data) onto newer high tech platforms. This until now required aquisitioning of external resources with specialised skillsets to get the 'Job Done'. Happily now this can be afforded to anyone with basic SQL skills. The utility inteprets the query and automatically populates a file with all the fields requested. Simply and Effectively, regardless of the SQL database. Once the respective ODBC driver is installed and Data Source Name is setup on the particular PC the utility is being executed.

Standard Version

• Connecting to any SQL Compliant Server & DataBase
• Scheduling Capability
• FTP Upload Capability
• Friendly Error Trapping Script Analyser
• Ability to Interpret SQL and populate a file Based on the fields stated in the SQL Statement
• Ability to Autoformat the populated file by Delimiter or Fixed Length properties
• Error Correction of Field selection in SQL statement
• Limited Support for Where Clause & String Comparison(Non Sub String)

Professional Version

The new features are as follows:

• Strict user control Enable/Disable of user buttons where applicable
• Multiple database instances saved to facilitate extracts from various database/tables using multiple SQL Select scripts
• Ability to Date/Time stamp ‘Dump’ files
• Auto Error correction capability in the event field data is corrupt or actual field names are incorrect
• Additional end of line characters Menu options
• SQL Resubmit on failure option
• Hourly Schedule option
• All Options are now saved upon exiting the application
• Intuitive responses to reflect SQL or Database Syntax Errors
• Full Support for Where Clause & String/Sub String Comparison
• Extended Support for (Where, Group by, Order By Clauses and Select within Select)

Data Integrator Pro 4.4 Installer  Or Get the Pro Document

Enhancements in Version 4.4

• Windows Service capability
• Improved SQL parsing
• Ability to set Minimum records to retrieve, if not satisfied no extract produced
• New MDAC support
• FTP Transfer Type can togglw between Binary (Default) and ASCII
• Separate Conditional SQL statement to determine if the Extract SQL Statement will be Executed
  • If left blank , no statement entered
  • If Conditional SQL Statement returns at least One(1) Row
• Ability to set Minimum records to be reached or file will not be produced
• Ability to set a select statement with a condition that must produce at least one record for the Extract SQL to produce results (Optional)
• Ability to set a schedule time for each DataBase schema entered
• Ability to either
  • Produce an extract File
  • Transfer the contents of the extract to another Database
• Ability to permit a job to execute every xx Hours and yy Mins for e.g. 00hr 30mins equates to running a job every 30mins
Video Walkthroughs
• Getting Started Quickly (Pro)

Special Notes

• Preferred use on Win2k/XP not Win2k/2k3 Server - Optimum Approach
• Installing and running on Win2k/XP does not prohibit accessing Databases running on Win2k/2k3/Linux/Unix Servers
• If connecting to an Oracle 10x/11x Database and issues arise, simply install Client Oracle 9x on a PC with Win2K/XP, then install the Extractor, configure DSN and you're set!

Licensing Fee's

	Standard	Professional
Cost per PC Install	US $400	US $850

UnRegistered

The unregistered version limits the number of records to 100 that can be extracted.

Registered

Registered version removes 100 record extract limit