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:

•Table
•View
•Clustered Index
•Procedure
•Triggers
•Rule
•Unique Index
•Non Clustered Index
•Index
•Function
•User defined data type
•Schema
•Column
•ForeignKey
•Stored Procedure
•PrimaryKeyConstraint

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:

•Tables
•Views
•Columns
•Procedures

Configure SELECT permissions on the following system tables:

•sysobjects
•syscomments
•sysdepends
•syscolumns
•sysindexes
•sysconstraints
•sysreferences
•sysusers
•systypes
•master.dbo.sysservers
•master.dbo.sysconfigures
•@@<servername

Prerequisites

To 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 restart the Catalog Service.

Alternatively, you can perform the following steps to complete the prerequisites:

1. Download the JDBC driver file and copy the file to the <INFA_HOME>/services/CatalogService/ScannerBinaries directory.
2. Open the <INFA_HOME>/services/CatalogService/ScannerBinaries/CustomDeployer/scannerDeployer.xml file and add the following lines in the file:

</ExecutionContextProperty>
<ExecutionContextProperty isLocationProperty="true" dependencyToUnpack="sybase_jars.zip">
<PropertyName>SybaseScanner_DriverLocation</PropertyName>
<PropertyValue>scanner_miti/sybase_jars/Drivers</PropertyValue>
</ExecutionContextProperty>

3. Save the scannerDeployer.xml file.
4. Restart the Catalog Service.

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
JVM 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.