| Database | How to connect |
|---|---|
| MS SQL Server | Enter or select server name at the direct connection panel |
| Local SQL Server Express | Enter .\SQLEXPRESS as server name at the direct connection panel |
| Oracle | 1) Switch to data sources mode 2) select OCI as "Interface" 3) select your service name from data source drop-down menu |
| DB2 | Use direct connection panel or
Use predefined ODBC DSN for custom connection settings |
| MySQL | Install ODBC driver for MySQL from www.mysql.org Use direct connection panel or Use predefined ODBC DSN for custom connection settings |
| PostgreSQL | Use direct connection panel or
Use predefined ODBC DSN for custom connection settings |
| Interbase/Firebird | Install ODBC driver Use direct connection panel or Use predefined ODBC DSN for custom connection settings |
| Microsoft Access | 1) Switch to "Desktop File" panel 2) Select "Access" as file type, enter or select file name |
| Microsoft Excel | 1) Switch to "Desktop File" panel 2) Select "Excel" as file type, enter or select file name |
| Another database | 1) Install ODBC driver for your database system 2) Create ODBC data source name using Windows ODBC Administrator 3) Switch to data sources mode 4) select your data source from drop down menu |