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:
- Open a business unit, right click Data Sources, click Data Sources, click Application specific ODBC, and then select the preferred MySQL native database.
- In the Name field, type the name of the data source.
- In the System DSN list, select the Data Source Name.
- In the Escape Character list, select the escape character specific to your ODBC driver.
- The Text Type Behavior fields are used to control how the ODBC driver handles text. These fields are optional. You have the following options:
Option Definition Set Length Specifies an exact text string length Set Variable Length True, if you want a variable text string length Set Unicode True, if you want to use Unicode
- In Set Number of Decimals, specify a fixed number of decimals. This field is optional.
- 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.
- Select Use Low Compatibility Mode if you have trouble retrieving data from the database.
- In the Command Timeout field, specify the number of seconds to wait before terminating the attempt to connect to the database.
- In the Connection Timeout field, specify the number of seconds to wait before terminating the attempt to connect to the server.
- 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.