I would like to insert data into a NoSQL DataBase (MongoDB).
The problem is I the format of my Json will change very often, example:
I can't know what will it be in my JSON.
So my question is how can I send a JSON to the component tMongoDBOutput, because I have the impression it needs a shema!
Feature of dynamic schema is not supported for MongoDB components as of now.
A new feature jira issue has been submitted to address it in future release.https://jira.talendforge.org/browse/TBD-3134
Could you try to make use of tExtractJson components and meet the requirement?
This new feature was created on February 2016, do you know if they are progressing?
I'm trying to make a dynamic json with tJavaRow and send it to tMongoDbOutput, but it's not working. Do you have any other ideas?
Feel free to vote for this new feature jira issue.
Depending up on your usecase, are you able to make use of tExtractJson components and meet the requirement else one can restrict to use set schema option?
I'll explain you my use case, maybe you'll have an idea I didn't think.
I'm listing a SQL Server Database, and when there is an insert or update in this Database, I get the new Data.
The row that will be returned to me may be different depending on the table that has just been modified (So I need a dynamic schema).
When I have this new data, I want to insert it in MongoDB. The problem is, my schema is dynamic and I can't push this dynamic schema to MongoDB.
What do you think?
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.