Cloud Pak for Data

Cloud Pak for Data

Come for answers. Stay for best practices. All we’re missing is you.

 View Only

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

    Posted 03/22/22 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
    ------------------------------

    #CloudPakforDataGroup


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

    Posted 03/23/22 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 03/24/22 03:54 AM
    Edited by System Admin 01/20/23 04:11 PM
    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
    ------------------------------

    Original Message


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

    Posted 04/13/22 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
    ------------------------------



Related Content