Enterprise Data Catalog Scanner Configuration Guide > Configuring Database Management Resources > Sybase
  

Sybase

You can configure a Sybase resource to extract metadata from Sybase databases.

Objects Extracted

Enterprise Data Catalog extracts metadata of the following schema objects from a Sybase resource:

Permissions to Configure the Resource

Before you create a Sybase resource, configure the permissions for the Sybase ASE database user account that you use to connect to the Sybase ASE database.
Configure SELECT permissions on the following schema objects:
Configure SELECT permissions on the following system tables:

Prerequisites

Download JDBC driver file
Complete the prerequisites to create a Sybase resource, download the JDBC driver JAR file from the Internet and copy the files to the SybaseScanner directory in the <INFA_HOME>/services/CatalogService/ScannerJars/externalDependencies directory. You need not recycle the Catalog Service.
Alternatively, you can perform the following steps to complete the prerequisites:
  1. 1. Download the JDBC driver file and copy the file to the <INFA_HOME>/services/CatalogService/ScannerBinaries directory.
  2. 2. Open the <INFA_HOME>/services/CatalogService/ScannerBinaries/CustomDeployer/scannerDeployer.xml file and add the following lines in the file:
    3. <ExecutionContextProperty isLocationProperty="true" dependencyToUnpack="sybase_jars.zip"> <PropertyName>SybaseScanner_DriverLocation</PropertyName> <PropertyValue>scanner_miti/sybase_jars/Drivers</PropertyValue> </ExecutionContextProperty>
  3. 3. Save the scannerDeployer.xml file.
  4. 4. Recycle the Catalog Service.
Update the JDBC driver file
To replace the obsolete JDBC driver jar with latest driver jar, perform the following steps:
  1. 1. Open the <INFA_HOME>/services/CatalogService/ScannerBinaries/ directory.
  2. 2. Replace the sybase-jdbc3 driver jar with sybase-jdbc4 in the sybase_jars.zip file.
  3. 3. Recycle the Catalog Service.

Basic Information

The General tab includes the following basic information about the resource:
Information
Description
Name
The name of the resource.
Description
The description of the resource.
Resource type
The type of the resource.
Execute On
You can choose to execute on the default catalog server or offline.

Resource Connection Properties

The following table describes the properties for the Sybase resource:
Property
Description
Host
Host name of the machine where Sybase database is hosted.
Port
Port number for the Sybase database engine service.
User
Database user name.
Password
The password for the database user name.
Database
Name of the database.
The following table describes the Additional and Advanced properties for source metadata settings on the Metadata Load Settings tab:
Property
Description
Enable Source Metadata
Select to extract metadata from the data source.
Schema
Specify a list of database or scheme to import.
Imported stored procedures
Specifies the stored procedures to import.
The default value is True or False whatever the case might be.
Case Sensitive
Specifies that the resource is configured for case insensitivity. Select one of the following values:
  • - True. Select this check box to specify that the resource is configured as case sensitive.
  • - False. Clear this check box to specify that the resource is configured as case insensitive.
The default value is False.
Memory
Specify the memory value required to run a scanner job.
Specify one of the following memory values:
  • - Low
  • - Medium
  • - High
Note: For more information about the memory values, see the Tuning Enterprise Data Catalog Performance article on How To-Library Articles tab in the Informatica Doc Portal
Custom Options
JVM parameters that you can set to configure scanner container. Use the following arguments to configure the parameters:
  • - -Dscannerloglevel=<DEBUG/INFO/ERROR>. Changes the log level of scanner to values, such as DEBUG, ERROR, or INFO. Default value is INFO.
  • - -Dscanner.container.core=<No. of core>. Increases the core for the scanner container. The value should be a number.
  • - -Dscanner.yarn.app.environment=<key=value>. Key pair value that you need to set in the Yarn environment. Use a comma to separate the key pair value.
  • - -Dscanner.pmem.enabled.container.memory.jvm.memory.ratio=<1.0/2.0>. Increases the scanner container memory when pmem is enabled. Default value is 1.
  • - -DskipExternalDatabaseObjects=true. Excludes all external objects such as schema, table, database and view.
Track Data Source Changes
View metadata source change notifications in Enterprise Data Catalog.
You can enable data discovery for a Sybase resource. For more information about enabling data discovery, see the Enable Data Discovery topic.
You can enable composite data domain discovery for a Sybase resource. For more information about enabling composite data domain discovery, see the Composite Data Domain Discovery topic.