Data360 Analyze

 View Only
  • 1.  Cosmos DB as source

    Posted 01-12-2024 05:00

    Is it possible to connect to a Cosmos DB using Analyze? Maybe via the JDBC query node?



    ------------------------------
    Jonas Sinnaeve
    Data Analyst
    Data Trust Associates
    ------------------------------


  • 2.  RE: Cosmos DB as source

    Employee
    Posted 01-16-2024 07:06

    A JDBC driver is available from a 3rd party vendor - CDATA - for the Azure Cosmos DB:

    https://www.cdata.com/drivers/cosmosdb/jdbc/

    I have not tried it but it appears that the JDBC driver could be used to connect the JDBC Query node to Cosmos DB. 



    ------------------------------
    Adrian Williams
    Precisely Software Inc.
    ------------------------------



  • 3.  RE: Cosmos DB as source

    Posted 01-16-2024 07:38

    Thanks for the info. Do you know someone or a company who tried this already?



    ------------------------------
    Jonas Sinnaeve
    Data Analyst
    Data Trust Associates
    ------------------------------



  • 4.  RE: Cosmos DB as source

    Posted 01-17-2024 05:33

    I'm interested too, I have this source scheduled to be harvested next month if possible.



    ------------------------------
    Marco de Jong
    CTO
    IntoDQ2
    ------------------------------



  • 5.  RE: Cosmos DB as source

    Employee
    Posted 01-18-2024 08:09

    The Vendor's information on the capabilities of the CDATA CosmosDB JDBC driver states the following for Metadata Discovery:


    Full support for JDBC DatabaseMetaData provides extensive schema discovery capabilities. Explore tables, columns, keys, and other data constructs based on user identity.



    ------------------------------
    Adrian Williams
    Precisely Software Inc.
    ------------------------------



  • 6.  RE: Cosmos DB as source

    Employee
    Posted 01-18-2024 08:06

    I have asked my colleagues and have not found any other customers that have already integrated Analyze with Cosmos DB



    ------------------------------
    Adrian Williams
    Precisely Software Inc.
    ------------------------------



  • 7.  RE: Cosmos DB as source

    Posted 01-19-2024 03:57

    Thanks Adrian, we'll give it a try.



    ------------------------------
    Marco de Jong
    CTO
    IntoDQ2
    ------------------------------