Oracle (Data Direct - SID)

Configure an Oracle datasource with DataDirect connection on your Guardium® system.

Supported Authentication Methods

Authentication Supported
Local user Yes
LDAP Yes
Kerberos No
SSL Yes
Mutual SSL Yes

Parameters

Field Description
Host Name/IP Required. The hostname or IP address of the datasource.
Port number Required. Default value: 1521.
SID name The Oracle system ID.
Schema The name of the database schema.
Connection property Properties that must be included in the JDBC URL to establish a JDBC connection with the datasource. The required format is property1=value;property2=value, where each property and value pair is separated by a semicolon.
For examples, refer to the database vendor's JDBC documentation.
Custom URL The connection string to the datasource. When the custom URL is not provided, the datasource connection is made by using properties such as the hostname and port number.

Example:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=hostname.domain.com|ip address )(PORT=1525)))(CONNECT_DATA=(SERVER=DEDICATED)(SID=Oracle_SID)))

Adding custom properties for classification

By default, the classifier uses count * to determine cardinality for random sampling. For Oracle datasources, Guardium supports alternative methods for determining cardinality: the DATA-CARDINALITY-FOR-SAMPLING-TABLES custom property for tables, and the DATA-CARDINALITY-FOR-SAMPLING-VIEWS-PERCENTAGE custom property for views.
DATA-CARDINALITY-FOR-SAMPLING-TABLES

When sampling tables, this custom property uses database statistics to determine cardinality. To enable the database statistics method, add DATA-CARDINALITY-FOR-SAMPLING-TABLES = STATISTICS as a custom property for the datasource. When using this property, the classifier retrieves the number of rows from the all_tables data dictionary view.

Notes:
  • The property name must be entered as DATA-CARDINALITY-FOR-SAMPLING-TABLES (all capital letters, with hyphens), and the only valid value is STATISTICS.
  • The value of num_rows in all_tables might not be up-to-date. When using this property, work with your Oracle administrator to ensure the database statistics are current.
  • After you run the discovery scenario with DATA-CARDINALITY-FOR-SAMPLING-TABLES = STATISTICS, click the Info icon for the data source in the Process Run Log. You can see that the datasource is using the custom property.
DATA-CARDINALITY-FOR-SAMPLING-VIEWS-PERCENTAGE

When sampling views, this custom property provides a percentage value that the classifier uses to determine the sample. To enable this method, add DATA-CARDINALITY-FOR-SAMPLING-VIEWS-PERCENTAGE = [0.000001 to <100] as a custom property for the datasource. This method uses sample_percent where the specified value is the probability that each row is selected for the sample.

Note:
  • The property name must be entered as DATA-CARDINALITY-FOR-SAMPLING-VIEWS-PERCENTAGE (all capital letters, with hyphens), and the allowed values are 0.000001 to <100.

You can add or change custom properties from either the Guardium UI or by using GRDAPI commands. After you add the custom properties, the information displays in the Details for datasource output. For more information about adding custom properties from the UI, see Configuring custom properties for your datasources.

You can also use GRDAPIs to manage custom properties. For example, assuming a datasource created with the following command:
grdapi create_datasource type="Oracle (DataDirect - SID)" user="dbusername" password="yourdbpassword" host="dbhostname" name="nameofthisdbconnection" shared=true application="Classifier" port=1521 serviceName="on9stuff" dbName="nameofschema"
Use the following commands to create the DATA-CARDINALITY-FOR-SAMPLING-TABLES and DATA-CARDINALITY-FOR-SAMPLING-VIEWS-PERCENTAGE custom properties:
grdapi create_datasource_custom_property name=DATA-CARDINALITY-FOR-SAMPLING-TABLES values=STATISTICS
grdapi create_datasource_custom_property name=DATA-CARDINALITY-FOR-SAMPLING-VIEWS-PERCENTAGE values=10
Then use the following commands to add the properties to the Oracle datasource:
grdapi add_custom_property_to_datasource_by_name customProps="DATA-CARDINALITY-FOR-SAMPLING-TABLES=STATISTICS" name="nameofthisdbconnection"
grdapi add_custom_property_to_datasource_by_name customProps="DATA-CARDINALITY-FOR-SAMPLING-VIEWS-PERCENTAGE=10" name="nameofthisdbconnection"
You can also use GRDAPIs to update the custom properties:
grdapi update_datasource_custom_property name=DATA-CARDINALITY-FOR-SAMPLING-VIEWS-PERCENTAGE addValues=1,2,5

For more information about the custom property APIs, see Datasource custom property APIs.

CAS (Configuration Auditing System) database instance

If you are a CAS user, configure the CAS database instance.

Field Description
Account The Oracle installation user.
Directory The directory of $ORACLE_HOME.