- Besides the main output that contains the fields from the deduced schema of a collection, there are separate outputs (a.k.a. composite outputs), setup for retrieving the field value for array items (those items are basically nested documents within the main MongoDB document).
- An additional standalone output with a single '$JSON' column enables retrieving the entire document contents as JSON string.
- An error output can be setup to redirect problematic records (in case of a failure processing a MongoDB document field value).
Use the parameters below to configure the component.
Select an existing MongoDB connection manager.
The number of documents returned per batch. To let MongoDB engine decide what's the optimal batch size, just leave the default value of 0. To disable batching, use a value of 1.
The MongoDB collection from which documents would be retrieved
The optional filter (i.e. MongoDB query) to apply on the selected source collection. Uses the standard MongoDB JSON syntax for query definitions.
An example of a simple query that find a document by its identifier is:
"_id" : ObjectId("5a57388f6f8dff702f254717")
The number of documents to analyze when deducing the schema of the MongoDB collection (i.e. outputs, columns names and column types).
The time zone for dates processing. Allows converting dates to UTC or local time.
For each array in the document, regardless of the depth of nesting, there will be created a composite output that enables retrieving the field values of its items. This output contains not only the fields of the array items, but also the fields from all parent record(s).
During runtime, the output will be populated with sets of rows, one set for each parent record. Each set of rows is separated with a blank row (all NULLs). Those blank rows are used for recreating the parent-child relationships in all SSIS+ components that support composite inputs (e.g. MongoDB Destination ). Tip: If you don't need the blank rows, you can set up the standard Conditional Split component to filter them out.
- New: Introduced component.
Ready to give it a try?
COZYROC SSIS+ Components Suite is free for testing in your development environment.