Forum Discussion

RGI's avatar
RGI
Icon for Helper III rankHelper III
7 years ago

Data Flow connect to on-premise Teradata Source

I can successfully connect to various data sources to create a data flow.

When I attempt to connect to Teradata I get the following message:

 

The evaluation could not be finished: Evaluation was cancelled, message: (Session ID: 44fcee91-d9d2-44b5-b1c1-443f061e6a0e)

 

The Teradata server is on-premise and I'm using my on-prem gateway. The same gateway is used to access various databases  (e.g.  MSSQL and Teradata) without a problem. So as far as I know the gateway is fine.

 

It's when I attempt to connect to the Teradata source via my gateway when building a data flow that I run into problems.

 

Can it be done?

Any ideas?

 

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi RGI,

     

    How did you create dataflow entity query? Can you please share more about these?
    BTW, current dataflow seems not support custom functions and advanced operations in queries.

     

    Regards,

    XIaoxin Sheng

    • RGI's avatar
      RGI
      Icon for Helper III rankHelper III

      These are the steps I take:

       

      Choose the workspace

      Click Create

      Click Dataflow

      Click Add New Entities

      Click Teradata database

      Enter server, gateway and authentication details

      Click Next

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        HI RGI,

         

        Did this issue only appears on teradata datasource? Have you use same authorization mode and corresponded credentials on it?


        In addition, you can also try to store this datasource as CDS-A entity, then get data from that entity if it works.

         

        Regards,

        Xiaoxin Sheng

  • I was hopeful when I saw the January update announcement for Dataflows (especially since the Teradata connector is specifically called out), however this error still persists.

     

    I can't even connect trying to use a blank query:

     

    I've selected my gateway and entered credentials but it just keeps popping back to "please specify how to connect".