Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.
The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…
Stambia Data Integration allows to work with MongoDB databases to produce fully customized Integration Processes.
A MongoDB Metadata is available to reverse all the Databases and collections, that can then be used in mappings to perform operations on the MongoDB server.
This articles explains the basics on how to use MongoDB in Stambia DI.
Please refer to this article to find all the necessary material.
Prerequisites:
- Stambia DI Runtime S17.3.0 or higher
- Stambia DI Designer S18.2.0 or higher
Create a new MongoDB Metadata:
Configure the root node:
| Property | Description |
| Name | Alias/label of the Mongodb server. |
| MongoDB URL |
MongoDB server URL. mongodb://[<user>:<password>@]<host>:<port> Some examples: mongodb://localhost:27017 mongodb://myUser:myPassword@localhost:27017 |
| MongoDB home |
Path to the MongoDB server installation directory. It is used by the templates importing data through the mongoimport utility. |
Each node of the MongoDB metadata offers the possibility to reverse its structure.
Simply right click on the desired node and choose: Actions > Reverse [All]
Add a database by right clicking on the server node and choosing New > Database.
| Property | Description |
| Name | Alias/label of the database |
| Database Physical Name |
Physical Name of the database. It will be used during data and reverse operations. |
You can reverse all the collections of the database with right click > Actions > Reverse.
Add a collection by right clicking on a database node and choosing New > Collection.
| Property | Description |
| Name | Alias/label of the collection |
| Collection Physical Name |
Physical Name of the collection. It will be used during data and reverse operations. |
You can then reverse the collection with right click > Actions > Reverse.
You can alternatively create the collection structure manually by adding its content with right click > New > [...].
MongoDB collections can be loaded from any database through the 'INTEGRATION Rdbms to MongoDB (crud)' template.
Note: Please refer to the template's internal documentation for more detailed information.
MongoDB collections can be accessed through the 'INTEGRATION Rdbms to MongoDB (crud)' template to load any database.
To read MongoDB data, you'll need to invoke it from a source to have a repetition key, like you would do for XML files or Web Services.
Tip: The source invoking MongoDB here is just used for the repetition key. We are using in our case a temporary in memory table to avoid using a 'real' table just for that. See this article to learn how to accomplish this.
Note: Please refer to the template's internal documentation for more detailed information.