Workflow Basics Guide

10.5
- 10.5.6
- 10.4.0

Back Next

PowerExchange for MongoDB JDBC Connections

When you configure a PowerExchange for MongoDB connection, you define the connection attributes that the PowerCenter Integration Service uses to connect to the MongoDB database.

The following table describes the MongoDB connection properties:

Property	Description
Connection Name	The name of the connection. The name is not case sensitive and must be unique within the domain. You can change this property after you create the connection. The name cannot exceed 128 characters, contain spaces, or contain the following special characters: ~ ` ! $ % ^ & * ( ) - + = { [ } ] \| \ : ; " ' < , > . ? /
Type	The connection type. Select MongoDB .
Host Name	Host name or IP address of the MongoDB server.
Port	MongoDB server port number. Default is 9042.
User Name	User name to access the MongoDB server.
Password	Password corresponding to the user name to access the MongoDB server.
Database Name	Name of the MongoDB database to connect to.
Additional Connection Properties	Enter one or more JDBC connection parameters in the following format: <param1>=<value>&<param2>=<value>&<param3>=<value> You must provide the JDBC parameters as ampersand-separated key-value pairs. You can configure the following JDBC connection parameters in a MongoDB connection: AuthSource BatchSize connectTimeoutMS DefaultStringColumnLength DmlBatchSize EnableDoubleBuffer EnableTransaction LogLevel LogPath SamplingLimit SamplingStepSize SamplingStrategy useJSONColumn For example, DefaultStringColumnLength=512&DmlBatchSize=1000& EnableDoubleBuffer=false&EnableTransaction=true& SamplingLimit=200&SamplingStepSize=2&SamplingStrategy=Backwards If you specify the host name, port number, user name, and password of the MongoDB server in the Additional Connection Properties , the values specified in the Additional Connection Properties takes precedence.
SSL Mode	Options applicable for MongoDB Connector are: disabled require or one-way

If you select the

Enable Reading/Writing as JSON

option, a column

documentAsJSON

appears in the collection when you read data from MongoDB through which you can read data as JSON. Default is disabled. To enable reading or writing as JSON, select

useJSONColumn

=true.

Connection Objects

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal