Skip to main content
Solved

API/Python code for onboarding (connections) the Databases into Ataccama

  • February 8, 2023
  • 3 replies
  • 214 views
V
Data Voyager
Forum|alt.badge.img+2

API/Python code for onboarding (connections) the Databases into Ataccama:-
We are trying to create Database connections into Ataccama by using Python. Is there any way to do the same. It would be really great if you can share us with any reference links or docs.

Thanks in advance!

Best answer by Maxim Kim

I would not give the exact code but the hints and a general answer as: yes it is possible (at least I belive so).

 

  1. Ataccama One uses graphql, so you can send REST requests to https://whateveyouroneinstance.com/graphql
  2. There is a mutation you can send that would add a new db connection to either an existing datasource or you can create a new datasource and a connection within it
  3. You should also be able to start profiling using the very same graphql endpoint
  4. python could be easily used to send those requests.

Now to get those graphql mutations would be something non-trivial…

View original

Maxim Kim
Ataccamer
Forum|alt.badge.img+3
  • Maxim KimAtaccamer
  • Ataccamer
  • February 8, 2023

Could you clarify a bit more what you mean by create DB connections?

Is it about creating DB `connection` entity inside `source` in Ataccama One Web using python?

Or is it about connecting to Ataccama One underlying database where all the metadata is stored?

Or do you want to connect to the database that is specified in Ataccama One Web using the connection of the source in python?

Or something completely different?

 

V
Data Voyager
Forum|alt.badge.img+2
  • vsoppa1Data Voyager
  • Data Voyager
  • February 14, 2023

Hello, @Maxim Kim, Thanks for your reply.

It is about creating a DB `connection` entity inside `source` in Ataccama One Web using Python.

We have database information, such as the system name, connection name , JDBC, and credentials. So, with the help of these details, we need to create a connection (on-boarding) into Ataccama One. 

(Moreover, this is for scanning the DBs.)

Maxim Kim
Ataccamer
Forum|alt.badge.img+3
  • Maxim KimAtaccamer
  • Ataccamer
  • February 14, 2023

I would not give the exact code but the hints and a general answer as: yes it is possible (at least I belive so).

 

  1. Ataccama One uses graphql, so you can send REST requests to https://whateveyouroneinstance.com/graphql
  2. There is a mutation you can send that would add a new db connection to either an existing datasource or you can create a new datasource and a connection within it
  3. You should also be able to start profiling using the very same graphql endpoint
  4. python could be easily used to send those requests.

Now to get those graphql mutations would be something non-trivial…

Reply


Community Terms of Use & 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