Cloud Pak for Data

 View Only
Expand all | Collapse all

Not able to access Data Virtualization with AutoAI on Cloud Pak for Data

  • 1.  Not able to access Data Virtualization with AutoAI on Cloud Pak for Data

    Posted Tue March 22, 2022 11:49 AM
    I sold a concept of Data Science Citizen connected to a Data Fabric, but the project has an issue accessing tables, we can't access data on Data Virtualization using Watson AutoAI.

    Our Data Science citizen can't consume date from this layer.

    AutoAI data use

    https://www.ibm.com/docs/en/cloud-paks/cp-data/4.0?topic=models-autoai

    ------------------------------
    DJALMA CERINO FILHO
    ------------------------------


  • 2.  RE: Not able to access Data Virtualization with AutoAI on Cloud Pak for Data

    Posted Wed March 23, 2022 09:24 AM
    I have come across this as well in a POC with a client where we use Data Virtualization extensively. Looking at the AutoAI documentation you can see that Data Virtualization is not one of the supported connection types -> https://www.ibm.com/docs/en/cloud-paks/cp-data/4.0?topic=models-autoai#autoai-data-use

    Create a support ticket at https://www.ibm.com/mysupport/s/ or create a feature request at https://hybridcloudunit-internal.ideas.aha.io/?project=CPDIDEAS

    In the meantime you need to convert data from the DV connection to a CSV. You can do that either using a Data Refinery job in your project or you can write a simple Python script to load data from the connection into a Pandas Dataframe and then simply write it out to a CSV. Ping me if you need those few lines of Python.

    Good luck

    Henrik Sjöstrand
    Partner Technical Specialist
    Data & AI
    IBM Sweden

    ------------------------------
    HENRIK SJÖSTRAND
    ------------------------------



  • 3.  RE: Not able to access Data Virtualization with AutoAI on Cloud Pak for Data

    Posted Thu March 24, 2022 03:54 AM
    Edited by Marcel Berkhout Thu March 24, 2022 04:20 AM
    You could consider creating a Db2 connection (which is supported according to that link Henrik shared) to DV, seeing that DV is running the Db2 BigSQL engine and therefore uses the same driver package. Haven't tried this myself to be honest, but worth a try I would say :-)

    Regards,
    Marcel

    ------------------------------
    Marcel Berkhout
    ------------------------------



  • 4.  RE: Not able to access Data Virtualization with AutoAI on Cloud Pak for Data

    Posted Wed April 13, 2022 08:01 AM
    We are submitting this enhancement at aha, if you are facing this same situation, please, verify and vote bellow at aha:

    AutoAI does not accept virtualized tables from Data Virtualization Private
    https://hybridcloudunit-internal.ideas.aha.io/ideas/CPDIDEAS-I-972



     



    ------------------------------
    DJALMA CERINO FILHO
    ------------------------------