Follow

ODBC Data Source

ODBC Data Source

Discovery Hub supports ODBC for retrieving data from a wide range of systems. Both application specific and a generic option is available.

Adding an ODBC Data Source

To add a new ODBC data source, follow the steps below:

  1. Open a business unit, right click Data Sources, click Data Sources and click Add Generic ODBC Data Source or Application specific ODBC followed by a click onthe system you want to connect to.
  2. In the Name field, type the name of the data source.
  3. In the System DSN list, select the Data Source Name.
  4. In the Escape Character list, select the escape character specific to your ODBC driver.
  5. The Text Type Behavior fields are used to control how the ODBC driver handles text. These fields are optional. You have the following options:
    OptionDefinition
    Set LengthSpecifies an exact text string length
    Set Variable LengthTrue, if you want a variable text string length
    Set Unicode True, if you want to use Unicode
  6. In Set Number of Decimals, specify a fixed number of decimals. This field is optional.
    Note: Convert out of range dates to MS SQL min/max is not available for Navision native databases.
  7. Select Use low compatibility mode if you have trouble retrieving data from the database.
  8. In the Command Timeout field, specify the number of seconds to wait before terminating the attempt to connect to the database.
  9. In the Connection Timeout field, specify the number of seconds to wait before terminating the attempt to connect to the server.
  10. If you want to add additional connection strings, click the Additional Connection Properties button. In the Connection String Properties window, type the preferred connection strings, and then click OK.
Was this article helpful?
0 out of 0 found this helpful

0 Comments

Please sign in to leave a comment.