Connecting to any other datasource

Table of Contents

You can connect BiG EVAL to any other datasource not listed in the documentation.

Please ensure that the following requirements are met:

  1. Install an OLEDB or ODBC driver on your BiG EVAL server.
    • BiG EVAL is a 64bit application. Therefore, you always need a 64bit driver.
  2. Create a datasource in BiG EVAL and choose either OLEDB or ODBC as the type.
    • When using OLEDB:
      • Lookup the connection-string for your driver on connectionstrings.com. Use the one, that contains the Provider= property.
    • When using ODBC:
      • Create a System-DSN (not a user-dsn) in the 64bit ODBC DSN Manager.
      • As a connection-string in the BiG EVAL datasource try to use the most simple version at first. Usually that’s enough:
        DSN=MyDsnName;
      • When you store user and password within your ODBC DSN, you usually don’t need to enter them in the connection-string again. Otherwise use:
        DSN=MyDsnName;UID=MyUsername;PWD=MyPassword;
      • Use connectionstrings.com for more information about the specific connectionstring of your driver.