SQLHELPER_JDBC_URI (Parameter)

Parameter: SQLHELPER_JDBC_URI

The JDBC URI(s) to connect to the database systems

This system parameter specifies the JDBC URI(s) used by an instance of the SAP CC system to connect to the database(s) after the startup phase.

Notes

At startup, each instance of the SAP CC system temporarily connects to the back-end database system for authentication. The JDBC URI of this database is specified in the boot.config configuration file and may differ from the URI stored in this parameter.
In case of multi-instance database system (Oracle RAC, IBM DB2 pureScale), this parameter is not used by the guider instances and by the rater instances of the SAP CC Core Server system. The SAP CC system takes into account the parameters SQLHELPER_JDBC_URI_DBIi (i from 1 to 12). See the SQLHELPER_DB_INSTANCE_COUNT parameter for more information and user assistance.

The format depends on the third-party database system.

Oracle with driver "thin": jdbc:oracle:thin:@<server>:<port>:<database_name>
In most cases:
- The port is 1521
MS SQL Server:
- IPv4: jdbc:sqlserver://<server>:<port>;DatabaseName=<database_name>;sendStringParametersAsUnicode=true[;IntegratedSecurity=true]
- IPv6: jdbc:sqlserver://;serverName=<server>;port=<port>;DatabaseName=<database_name>;sendStringParametersAsUnicode=true[;IntegratedSecurity=true]
Notes:
- In most cases, the port is 1433
- The IPv6 format can also be used for IPv4 addresses
- The JDBC driver supports the use of Type 2 integrated authentication on MS Windows operating systems through the IntegratedSecurity connection string property. In such a situation, no value for SQLHELPER_LOGIN and SQLHELPER_PASSWORD is required
DB2: jdbc:db2://<server>:<port>/<database_name>:<prop1>=<value1>;<prop2>=<value2>
In most cases:
- There is no property
- The port is 4464
Sybase ASE: jdbc:sybase:Tds:<server>:<port>/<database_name>?<prop1>=<value1>&<prop2>=<value2>
In most cases:
- There are 2 properties:
  - HOMOGENEOUS_BATCH=false
  - SUPPRESS_PARAM_FORMAT=false
- The port is 5000
SAP HANA: jdbc:sap:<server>:<port>
In most cases:
- The port is 3<INSTANCE_NUMBER>15, where <INSTANCE_NUMBER> is the instance number of the SAP HANA database

For more information, consult this section.

Name	`SQLHELPER_JDBC_URI` The JDBC URI(s) to connect to the database systems
Category	Parameter
Type	String
Access (RO/RW)	RW(-): Dynamic Read / Static Write An immediate change is not possible. For a deferred and permanent change, use the `set` command of the Admin+ user interface to change the parameter value for a specific type of instance in the SAP CC Core Server system. A restart is needed for permanent changes.
Groups	Security Management Settings Backends: Database Management Settings
Instance Types	This system parameter is available in the following types of instances in a running SAP CC Core Server system: rater, updater, guider, bulkloader, taxer, dispatcher