PowerExchange for MongoDB User Guide

10.5.4
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.4.0

Back Next

MongoDB Read Operations Overview

You can import a MongoDB collection as an ODBC data object in the Developer tool and use it as a source in a mapping.

When you run a MongoDB mapping, the Data Integration Service uses the Informatica MongoDB ODBC data source to extract data from MongoDB.

You can configure the optimization levels at the following locations:

Mapping runtime configuration in the Developer tool

Data viewer runtime configuration in the Developer tool

Mapping deployment in application settings in the Developer tool

Mapping configuration of an application in the Data Integration Service through the Administrator tool

You can configure advanced reader properties for the Informatica MongoDB ODBC Driver in the ODBC driver properties.

You can configure the following read options in the ODBC driver properties:

Read Preference: MongoDB server that you prefer to read data from if you configure replica sets.

You can select one of the following MongoDB server options:
Primary. The Data Integration Service reads data from the primary MongoDB server. If the primary MongoDB server is offline, the session fails.
Primary Preferred. The Data Integration Service reads data from the primary MongoDB server if the primary MongoDB server is available. If the primary MongoDB server is offline, the Data Integration Service reads data from the secondary MongoDB server.
Secondary. The Data Integration Service reads data from the secondary MongoDB server. If the secondary MongoDB server is offline, the session fails.
Secondary Preferred. The Data Integration Service reads data from the secondary MongoDB server if the secondary MongoDB server is available. If the secondary MongoDB server is offline, the Data Integration Service reads data from the primary MongoDB server.
Nearest. The Data Integration Service reads data from the nearest available MongoDB server.
Enable Reading/Writing as JSON: Reads MongoDB datasource as a JSON document. If you select the option, a column with documentAsJSON appears in the collection when you read data from MongoDB from which you can read data as JSON.
Documents fetched per block: The maximum number of documents fetched from the MongoDB server for every read request. If more documents are available for a query, the Data Integration Service makes further read requests to the MongoDB server. Default is 4096.

Rename Saved Search

Table of Contents

PowerExchange for MongoDB User Guide

PowerExchange for MongoDB User Guide

MongoDB Read Operations Overview

MongoDB Read Operations Overview