SOURCEDB parameter for databases or data sets that require a data source name or identifier to be specified explicitly as part of the connection information. This option is required to identify one of the following:
The source login database for heterogenous databases.
The data source name (DSN) for supported databases that use ODBC
The source SQL/MX catalog, valid when Extract will process data from only one catalog in the SQL/MX database
The default DB2 for i database.
Tables specified in
TABLE statements that follow
SOURCEDB are assumed to be from the specified data source.
You might need to use the
USERIDALIAS parameter in the
SOURCEDB parameter statement, depending on the authentication that is required for the data source.
For databases that allow authentication at the operating-system level, you can specify
For Manager, use
SOURCEDB only when using Oracle GoldenGate parameters that cause Manager to interact with a source database, such as
PURGEOLDEXTRACTS. You can use
SOURCEDB for Manager on the source or target database.
For DB2 LUW, the
SOURCEDB statement must refer to the database by its real name, rather than by any alias.
SOURCEDB data_source[, SESSIONCHARSET character_set]
The name of the database, catalog, or data source name as applicable for the database.
For MySQL databases, you can use the format of
host_name to avoid connection issues caused by the incorrect configuration of
localhost in the local hosts file. If running MySQL on a port other than the default of 3306, you must specify the port number in the connect string:
Supports Sybase, Teradata and MySQL. Sets the database session character set for the process login session. This parameter overrides any
SESSIONCHARSET that is specified in the
To display the language information in the process report file when using this option for a Sybase database, make certain that
locale.dat is set properly in the Sybase installation directory. If the character set is not found in the supported Sybase database character set, then it is validated against the Oracle GoldenGate supported character set list. The character-set information is displayed with the
LOCALE INFORMATION entry in the report output.