Data360 Analyze

 View Only

  • 1.  New Data Flow

    Posted 07-12-2022 09:12
    Hi gang, I am trying to set up a data flow for the SQL Server connector in Analyze.
    I am trying to see the best way to get Govern API Secret and API Key. I am copying it from the Govern - profile picture> API Key > and API Secret. Is that the right place to get this secret and key? I am just copying it over to Analyze.  Thanks

    ------------------------------
    Zahid Kamal
    CENTRAL MUTUAL
    Van Wert OH
    ------------------------------


  • 2.  RE: New Data Flow

    Posted 07-13-2022 12:37
    Hi Zahid,

    You mean the Database Harvester for Govern connecting to SQL Server right.
    To push the meta data to Govern you need the API Keys and yes the best way to do this is via your profile and copy them.

    Regards

    Marco

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

    Original Message


  • 3.  RE: New Data Flow

    Posted 07-13-2022 14:31
    Yes, Marco. That's what I am trying to do. The SQL Server database side is working ok. I see the tables/columns are getting pulled. It is the Govern side is not able to load the data. I selected API secret and key from Govern/login. I am still getting an execution error: Execution ErrorUnexpected error occurred during cleanup while running the node: java.lang.IllegalStateException: Transition close not valid from CLOSED_WITH_ERROR_STATE state.

    Now I am trying to review each step - trial and error kind of approach.

    ------------------------------
    Zahid Kamal
    CENTRAL MUTUAL
    Van Wert OH
    ------------------------------

    Original Message


  • 4.  RE: New Data Flow

    Posted 07-14-2022 08:35
    Hi Zahid,

    This is not caused by your API Key / Secret Key.
    Depending on your Harvester version and JDBC_Path_Option Connector in Govern.
    I think you need to open a case with support and give the error message and which node in the harvester is failing with the version number.

    Regards

    Marco



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

    Original Message


  • 5.  RE: New Data Flow

    Posted 07-14-2022 10:14
    You are right, Marco. I got to a point where I think creating a new support ticket is the next logical step. Thanks.

    ------------------------------
    Zahid Kamal
    CENTRAL MUTUAL
    Van Wert OH
    ------------------------------

    Original Message