The problem is that when sending JSON objects to Mongo or Json File

Question

Hello everyone, I have an issue when trying to send data to MongoDB from a PostgreSQL database using a copy activity in Azure Data Factory. The problem is that when sending JSON objects to Mongo or Json File, they appear as if they were strings. I tried sending it first to a JSON file, but it's the same; it's detected as a string and not as a JSON object. I already changed the mapping to specify that it's JSON, but it's not working.

Answer 1

First thing to think about it is to verify that the data being exported from PostgreSQL is in a valid JSON format. Sometimes, when data is extracted, it might be serialized as a string to ensure compatibility during the transfer. You may need to explicitly cast or convert it to a JSON format before or during the transfer process.

Another detail in Azure Data Factory, when setting up the copy activity, ensure that you are correctly specifying the output format. If the data is being interpreted as a string, it's possible that the serialization settings or the sink's dataset definition in Data Factory needs adjustment.

For MongoDB, make sure that the sink dataset is correctly configured to handle JSON as objects. MongoDB expects JSON-like structures (BSON), so ensure that your mapping or schema definition in Data Factory allows for this.