PowerExchange for MongoDB JDBC User Guide for PowerCenter

Back Next

Configure MongoDB JDBC Source Session Properties

You can configure the session properties for a MongoDB source on the

Workflow Manager

tab. Define the properties for the source instance in the session.

The following table describes the session properties that you can configure for a MongoDB source session:

Session Property	Description
Pre-SQL	The pre-SQL commands to run before the PowerCenter Integration Service reads data from the source.
Post-SQL	The post-SQL commands to run after the PowerCenter Integration Service reads data from source.
Filter Override Type	The type of filter expression that you want to override in the source qualifier. You can select Native or Platform filter expression type to override. Default is None.
Filter Override	The filter condition that overrides the filter condition you specify in the source qualifier. After you select Native or Platform Filter Override Type, specify the filter condition to override in the source qualifier. When you configure a Platform filter override, you must specify the absolute qualified column name in the following format: tablename.columnname