Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. Appendix A: Session Properties Reference
  17. Appendix B: Workflow Properties Reference

PowerExchange for MongoDB JDBC Connections

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.