BI JDBC System Properties

Use

The BI JDBC system template provides business intelligence functionality to systems that you create based on JDBC-compliant data sources. The template for a BI JDBC system defines the specific parameters needed to connect to these data sources, and contains a reference to the BI JDBC connector and a reference to the JDBC driver for your data source.

Note

There is a difference between systems created with the JDBC system template and the BI JDBC system template. BI JDBC systems provide access to JDBC tables and business intelligence functionality in, for example, Visual Composer, whereas systems based on the JDBC system template provide access to stored procedures and do not involve business intelligence functionality.

Ensure that a JDBC driver for your data source has been loaded on the Java AS.

Property	Value
Category: BI / Business Intelligence
BI Directory Provider	If Yes , specifies that this BI system can be accessed from applications in the Business Explorer suite, where supported.
Category: Connection Properties
Connection URL	Defines the JDBC connection URL to the system. Mandatory. Along with the Driver Class Name property and the User/Password values supplied by the User Mapping Service, this property enables connection to the external application. For example: `jdbc:microsoft:sqlserver:// <hostname>:<port>; database=Northwind`
Driver Class Name	Defines the JDBC driver used to connect to the system. Mandatory. Along with the Connection URL property and the User/Password values supplied by the User Mapping Service, this property enables connection to the external application. For example: `com.microsoft.jdbc.sqlserver. SQLServerDriver`
Fixed Catalog	Restricts metadata access to metadata contained in specified catalog. Optional. For example: `null` (no restriction) `xyz` (restrict to catalog "xyz")
Fixed Schema	Restricts metadata access to metadata contained in specified schema. Optional. For example: `null` (no restriction) `xyz` (restrict to schema "xyz")
Category: Information	The property values in this category are assigned during the running of the System wizard and, except for Description , Object is a Template , and System Name are not for editing.
Description	An optional description of the system, if one was not inserted during the running of the System wizard.
Object is a Template	Defines the system you have created as a template upon which you can base other systems. If selected, this sytem will appear as a template the next time you go to create a system.
System Name	The name assigned to the system when running the System wizard. Mandatory, exists for each system.
Category: User Management
User Mapping Type	Defines the type of user mapping needed for connection; who can perform user mapping Valid values: user/admin/admin,user For more information, see Editing System Properties .
Category: Show All
CodeLink	A reference to the portal component upon which the system is based. Mandatory; assigned while running the System wizard.
com.sap.portal.reserved.system. ConnectionFactoryClass	The JNDI name of the BI JDBC Connector, through which the system connects. It must take the form `SDK_XXXX` and the letters must be all upper-case. Mandatory when working with a connector.
ComponentType	The portal component (system) you have just created. Mandatory; required by the system landscape service.
System Type	Type of system. Mandatory; assigned while running the System wizard.