1. From the Progress DataDirect program group, start the ODBC Administrator and click either the User DSN, System DSN, or File DSN tab to display a list of data sources.
User DSN: If you installed a default DataDirect ODBC user data source as part of the installation, select the appropriate data source name and click Configure to display the driver Setup dialog box.
If you are configuring a new user data source, click Add to display a list of installed drivers. Select the appropriate driver and click Finish to display the driver Setup dialog box.
System DSN: To configure a new system data source, click Add to display a list of installed drivers. Select the appropriate driver and click Finish to display the driver Setup dialog box.
File DSN: To configure a new file data source, click Add to display a list of installed drivers. Select the driver and click Advanced to specify attributes; otherwise, click Next to proceed. Specify a name for the data source and click Next. Verify the data source information; then, click Finish to display the driver Setup dialog box.
The General tab of the Setup dialog box appears by default.
Note: The General tab displays only fields that are required for creating a data source. The fields on all other tabs are optional, unless noted otherwise in this book.
2. On the General tab, provide the following information; then, click Apply.
Host Name: Type either the name or the IP address of the server to which you want to connect.
Port Number: Type the port number of the server listener. The default port number for the Apache Hive server is 10000.
Database Name: Type the name of the Apache Hive database to which you want to connect by default. The database must exist, or the connection attempt will fail.
Transport Mode: If you are connecting to an HTTP endpoint, set to 1 - HTTP. By default, the driver attempts to establish a binary connection (TCP mode).
HTTPPath: If Transport Mode is set to 1 - HTTP, type the path of the HTTP/HTTPS endpoint used for connections. The default is cliservice.
3. On the Security tab, provide the following information; then, click Apply.
User Name: Type the default user ID that is used to connect to your database.
4. For Microsoft Access and Tableau users, click on the Advanced tab. Provide the following required value for the Max String Size option; then, click Apply.
For Microsoft Access: Type 255
For Tableau: Type a value from 255 to 4000 that suits your environment.
User DSN: If you installed a default DataDirect ODBC user data source as part of the installation, select the appropriate data source name and click Configure to display the driver Setup dialog box.