Sun's JDBC (Java Database Connectivity) is the standard Java API for Relational Database Management Systems (RDBMS). The BI JDBC Connector allows you to connect applications built with the BI Java SDK to over 170 JDBC drivers, supporting data sources such as Teradata, Oracle, Microsoft SQL Server, Microsoft Access, DB2, Microsoft Excel, and text files such as CSV. This connector is fully compliant with the J2EE Connector Architecture (JCA).
You can also use the BI JDBC Connector to make these data sources available in SAP BI systems using UD Connect. You can also create systems in the portal that are based on this connector.
The connector adds the following functionality to existing JDBC drivers:
The JDBC Connector implements the BI Java SDK's IBIRelational interface.
The BI JDBC Connector supports all JDBC-compliant data sources.
If you have not already done so, you need to deploy your data source's JDBC driver to the server: SeeManaging JDBC Driversfor more information.
The table below lists all required and optional properties for the configuration of your connector:
BI JDBC Connector Properties
Property |
Description |
Examples |
UserName |
Data source username. User must have at least read access to the data source. |
(your user name) |
Password |
Data source password. |
(your password) |
URL |
URL string specifying the location of a database (used by the java.sql.DriverManager to determine which driver to use). |
jdbc:inetdae7:domain:port?database=mydatabase |
DriverName |
Class name of the JDBC driver used for this connection. |
com.inet.tds.TdsDriver |
FixedCatalog |
Restriction of metadata access to metadata contained in specified catalog. Optional |
null (no restriction) xyz(restrict access to catalog "xyz") |
FixedSchema |
Restriction of metadata access to metadata contained in specified schema. Optional. |
null (no restriction) xyz(restrict access to schema "xyz") |
Language |
Language key made up of two letters. This indicates the language of exceptions that can be called on the BI Java SDK Layer. JDBD databases do not support this property. Optional. |
EN=English DE=German |
See also: