Adding Relational Data Sources
The process of adding relational data sources for use with TDV is fundamentally the same for all types.
In the New Physical Data Source dialog, you need to provide the connection details that are used each time TDV accesses the data source. You can edit this information later if necessary when you open this data source in Studio. TDV automatically populates some fields for each data source type.
Refer to the corresponding Adapter guides for a description of the fields on the two data source configuration tabs.
To add a relation data source
1. Make sure that any required drivers are installed and configured for use with Studio. For details on obtaining the adapter and for proper placement of the JDBC JAR files, see the corresponding TDV Adapter Guide.
2. For Netezza, go to Administration > Configuration and set the “Check if nested aggregates is supported by datasource” configuration parameter to True if that is the case.
3. For Hive 1.1.0, create a view of the table and use Show Contents from the view.
4. Right-click at an appropriate location in the resource tree, and select New Data Source.
Studio displays the first frame of the New Physical Data Source dialog, which lists the available data source adapters, including custom adapters that may have been configured and added to TDV.
5. Search for and select the data source adapter type, and click Next.
— For Cloudera CDH4, select Hive 1.1.0 (HiveServer2) as the data source adapter.
— For DB2 v9.5, select one of the DB2 v9 adapters.
— For Microsoft Access data sources on non-windows platforms, select the Non ODBC Microsoft Access adapter.
— For Oracle 11g using the type 2 native client (OCI), select Oracle 11g (OCI Driver) as the data source adapter.
— For Oracle 11g using the Type 4 Java-only client (thin driver), select Oracle 11g (Thin Driver) as the data source adapter.
— Select the Sybase option that matches your version of the data source adapter.
If You Are Using Sybase Version | Use Sybase Option | Driver Required |
Sybase v12.x | Sybase 12 | jConnect for JDBC 16 |
Sybase v15.x | Sybase 15 | jConnect for JDBC 16 |
Sybase IQ v15 using JDBC Type 4 driver | Sybase IQ | jConnect for JDBC 16 |
Sybase IQ v15 using JDBC Type 2 driver | Sybase IQ (Type 2) | SQL Anywhere Database Client v12.0.1 |
Note: If none of the data source types are appropriate, see
Custom Adapters for more information.
6. Enter the name for the data source as you want it to appear in Studio resource tree.
7. Enter the basic connection information for the data source. See the Adapter Guide for the specific datasource, for a description of the basic settings.
8. To enable Kerberos security through keytab files, select the Kerberos option on the Basic tab. You can then type values for the Keytab File and the Service Principal Name fields.
9. Enter the connection values and related fields. See the Adapter Guide for the specific datasource, for an overall description of the advanced settings.
Note: Many of these fields control connection pools. Connection pool configuration uses the standard settings that you can find on the internet.
10. Scroll down to make sure that you have specified all necessary information.
For additional fields and options, see the section about the specific data source you are adding.
11. Click one of these options:
— Create & Close—Save the data source definition but do not introspect now.