Solved

Can i Use Alteryx ETL Tool to ingest data to CDF.

  • 6 October 2023
  • 7 replies
  • 110 views
K
Rank
Userlevel 2
Badge +2

How can i connect to CDF, using Alteryx ETL tool.

Is there any documentation available?

icon

Best answer by Einar Omang 9 October 2023, 08:33

View original

7 replies

E
Rank
Userlevel 2

Hi,

This isn't something we've really looked at, and we have no official guidelines for this source system. From reading the documentation it looks like there may be ways to develop custom plugins, but this isn't something we are able to help much with.

Here’s the alteryx SDK: https://pypi.org/project/ayx-python-sdk/

Here’s the cognite SDK: https://pypi.org/project/cognite-sdk/

You may be able to use these together to build a custom connector.

H
Rank

Hi Einar Omang,

As per Cognite recommended documentation, we are using the postgres gateway where it is  the recommended way to connect from an ETL. 

https://docs.cognite.com/cdf/integration/guides/interfaces/postgres_gateway/

However ever after following the documentation, we are unable to establish  connection using the raw database name.

can you help here.

 

Regards,

Harsha Vardhan.

E
Rank
Userlevel 2

What have you tried, and how is it failing?

K
Rank
Userlevel 2
Badge +2

Hi Omang,

 

We are trying to write data to CDF using Alteryx ETL tool.

Although direct support/connector is not available. Cognite documentation says we can use PostgreSQL gateway setup Setup and administration | Cognite Documentation .This says , you can connect from any ETL tool which provides PostgreSQL Interface .Alteryx has this PostgreSQL capability.

So, we have setup the same steps & tried to write data from Alteryx.  we are unable to establish  connection using the raw database name.

 

E
Rank
Userlevel 2

I understand that, but what, exactly, did you do, and how is it going wrong.

K
Rank
Userlevel 2
Badge +2

Hi Omang,

We have followed the step-by-step procedure mentioned in the documentation .https://docs.cognite.com/cdf/integration/guides/interfaces/postgres_gateway/.

After doing all these, we were not able to establish connection to CDF.

C
Rank
Userlevel 3

Hi @Kumar Varaganti Sharath, would you mind elaborating at which step things stop working? Have you succesfully completed the first 4 steps without running into issues? Or are you already seeing errors there? A little more detail on what errors you are getting, where things go wrong will help us to better help you. 

Reply


Terms & ConditionsCookie Settings