Skip to main content
Solved

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

K
Committed
Forum|alt.badge.img+2

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

Is there any documentation available?

Best answer by Einar Omang

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.

View original
K
1 person likes this
  • K
    Kumar Varaganti Sharath
Did this topic help you find an answer to your question?

7 replies

E
Practitioner
  • Einar Omang
  • Practitioner
  • 68 replies
  • Answer
  • October 9, 2023

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
Committed
  • Harsha
  • Committed
  • 9 replies
  • October 11, 2023

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
Practitioner
  • Einar Omang
  • Practitioner
  • 68 replies
  • October 12, 2023

What have you tried, and how is it failing?

K
Committed
Forum|alt.badge.img+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
Practitioner
  • Einar Omang
  • Practitioner
  • 68 replies
  • October 13, 2023

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

K
Committed
Forum|alt.badge.img+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
Seasoned Practitioner
  • Carin Meems
  • Seasoned Practitioner
  • 223 replies
  • October 16, 2023

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

Cookie Policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings