Data Integration

 View Only
Expand all | Collapse all

How to write the data to MongoDB using ODBC connector stage in Datastage 11.7 version?

  • 1.  How to write the data to MongoDB using ODBC connector stage in Datastage 11.7 version?

    Posted Tue July 13, 2021 09:40 AM

    I have received the below error message. how to resolve this?

    " ODBC_Connector_1,0: ODBC function "SQLExecute" reported: SQLSTATE = 25000: Native Error Code = -3,706: Msg = [IBM (DataDirect OEM)][ODBC MongoDB driver][MongoDB]invalid transaction state: read-only SQL-transaction (CC_OdbcDBStatement::executeInsert, file CC_OdbcDBStatement.cpp, line 838)"






    #DataIntegration
    #DataStage
    #Support
    #SupportMigration


  • 2.  RE: How to write the data to MongoDB using ODBC connector stage in Datastage 11.7 version?

    Posted Thu July 29, 2021 09:11 AM

    The  MongoDB driver data source has the connection parameter ReadOnly, if set to1(enabled) the connection has read-only access.

     

    Source: https://knowledgebase.progress.com/articles/Knowledge/All-inserts-to-MongoDB-fail-with-invalid-transaction-state-error






    #DataIntegration
    #DataStage
    #Support
    #SupportMigration