- Knowledge & Support
- Integration
Import using ODBC
1) Create System DSN using ODBC Data Sources (64bit) Program.
Note: You will need to install ODBC drivers to fit your specific needs (e.g. Excel, MYSQL, etc.)
2) Using the Instance Manager set:
– Import Connection Type: ODBC
– Server Name: “ODBCname”
– User Name: “Leave blank”
– Password: “Leave blank”
The resulting connection string will look like:
DSN=DSNname;Integrated security=SSPI
or (if using Username and Password)
DSN=DNSname;UID=abc;PWD=123