Our ETL software works on Windows only.
Below is a List of Software that must be installed before installation of ETL Software:
| Software | Version | Notes | |
|---|---|---|---|
| Microsoft Windows XP or higher | |||
| FoxPro ODBC driver | 6.1.8629.1 or higher | Separate download | Only to work with DBF/FoxPro Files |
| SQL ODBC driver | 2000.81.9041.40 or higher | Part of OS | Only to import data into MS SQL Server 2008/2019 |
| Interbase client | GDS32.DLL | Only to work with Interbase or Firebird Databases | |
| Oracle Client | 7.3.4 or higher | Provided by Oracle | Only to work with Oracle Databases |
| SQLite | Sqlite3.dll | Only to work with SQLite databases | |
| BDE Drivers | Latest Version | Only to work with Paradox or other BDE databases | |
| Tableau Client | Latest Version | Only to work with Tableau |
https://github.com/VFPX/VFP9SP2Hotfix3/blob/master/ODBC_Release_Notes.md
https://github.com/VFPX/VFP9SP2Hotfix3/blob/master/OLEDB_Release_Notes.md
https://www.microsoft.com/en-gb/download/details.aspx?id=13255
https://www.etl-tools.com/dmdocuments/BDE.zip
https://www.python.org/downloads/
The installation may use up to 120 meg of disk space. We recommend using 8 gigabytes of memory. Our software streams data, therefore, having loads of memory is not going to improve performance. (eg: it does not load all the data into memory at once).
We do have customers running our ETL software on low-end servers in the cloud.
Most of the time two i7 processors and 16 gigs of memory is more than enough. We prefer not to force someone to buy expensive hardware which is not going to be used. It is better to start small and upgrade later.
The repository database stores all the information about connections, transformations, packages, SQL scripts, reports and execution logging. This is where the results of ETL designer hard work is stored and obviously, no one wants to lose it.
Repository database takes approximately 200 megs.
For more technologies supported by our ETL Software see Advanced ETL Processor Versions