The supported database types for the SQL connection in Enterprise Studio are Microsoft SQL Server, MySQL and IBM DB2 (only tested for Windows, Linux is unknown).
Enterprise Studio uses an OLE DB or ODBC API to connect to an SQL database. You may have to install the drivers for this on the computer from which the import and export are performed. If the SQL database has been installed on the same computer, these drivers may already be included in this installation.
- For SQL Server, the Microsoft SQL OLE DB provider is used.
- For MySQL, ODBC is used (by default the MySQL ODBC 5.3 Unicode Driver, but this can be modified). The driver can be downloaded from:
- For IBM DB2, the IBM OLE DB provider (IBMDABD2) is used.