Follow

Oracle MySQL Data Source

Oracle MySQL Data Source

Discovery Hub supports MySQL data sources through ODBC.

Adding a MySQL Data Source

To add a MySQL data source, follow the steps below:

  1. Open a business unit, right click Data Sources, click Data Sources, click Application specific ODBC, and then select the preferred MySQL native database.
  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 UnicodeTrue, if you want to use Unicode
  6. In Set Number of Decimals, specify a fixed number of decimals. This field is optional.
  7. Select Convert out of range dates to MS SQL min/max if you want to convert all dates older than January 01, 1753 to 01-01-1753.
  8. Select Use Low Compatibility Mode if you have trouble retrieving data from the database.
  9. In the Command Timeout field, specify the number of seconds to wait before terminating the attempt to connect to the database.
  10. In the Connection Timeout field, specify the number of seconds to wait before terminating the attempt to connect to the server.
  11. 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.