Seasoned ⭐️⭐️

Solved

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

7 replies
200 views

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

Is there any documentation available?

E

Einar OmangAnswer

Practitioner ⭐️⭐️⭐️

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.

E

Einar OmangAnswer

Practitioner ⭐️⭐️⭐️

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

Harsha

Seasoned ⭐️⭐️

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

Einar Omang

Practitioner ⭐️⭐️⭐️

What have you tried, and how is it failing?

K

Kumar Varaganti SharathAuthor

Seasoned ⭐️⭐️

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

Einar Omang

Practitioner ⭐️⭐️⭐️

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

K

Kumar Varaganti SharathAuthor

Seasoned ⭐️⭐️

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

Carin Meems

Expert ⭐️⭐️⭐️⭐️

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.

Sign up

Welcome to Cognite Hub