locked
In Azure Data Factory string fields are truncated on MongoDB Connector RRS feed

  • Question

  • Hi,

    I'm have a CosmosDB with Mongo API.

    I have to dump data from Cosmos DB to Azure SQL.

    I have used MongoDB Connector while linking with Cosmos DB as my data source.

    I've created a Copy Activity, it runs successfully. 

    But the issue is string get's truncated to 255.  Data is get's truncated when I have greater then 255 characters.

    Is this the limitation of Azure Data Factory for MongoDB Connector or I am  missing something ?

    What could be the alternatives ?

    Regards,

    jayanta


    Tuesday, August 14, 2018 5:37 AM

All replies

  • Hi Jayanta,

    Yes, currently the mongodb connector will truncate string with more than 255 characters. We're working on a new connector specifically for CosmosDB with mongo API. Please stay tuned.

    Thanks.

    Wednesday, August 15, 2018 1:16 AM