Integration
      Back to home
      1. Knowledge & Support
      2. Integration

      Import using ODBC

      1) Create System DSN using ODBC Data Sources (64bit) Program.
      – Note you’ll need to install ODBC drivers to fit your specific need. (Excel, MYSQL, etc.)

      2) Using Instance Manager set…
      – Import Connection Type: ODBC
      – Server Name: “ODBCname”
      – User Name: “leave blank”
      – Password: “Leave blank”

      ODBC

      The resulting connection string will look like:

      DSN=DSNname;Integrated security=SSPI

      or (if using Username and Password)

      DSN=DNSname;UID=acb;PWD=123