Connect to Magento Database on Cloud from MAC/ODI

[s_smith]

Hello

I am new to the whole Magento Cloud and Python as well.

I am trying to figure out steps to connect to Magento Database on the cloud and query for orders, and hopefully get them in our local warehouse using ETL.

Intention is to use the Python Magento API to do the later.

But I am at a stage where after having gone through bunch of documentation, haven't been able to make much progress.

Is there a step by step guide anyone has followed to use Oracle Data Integrator (ODI) to connect to select orders or used Python from local Mac, and can tell me what steps should be followed.

Thanks

[Tarandeep Singh]

@s_smith 

Could not understand 100% but seems like this may help.

There are 2 ways to connect to DB.

1. SSH on to the Magento Cloud environment and then connect to the mysql/database.

2. If you want to connect to cloud DB from your local then you need to enable SSH tunneling. Below documentation URL can help you on setting up SSH tunneling and making DB connection from your local machine.

https://devdocs.magento.com/guides/v2.3/cloud/env/environments-ssh.html

[ITSolution9700]

I will try to explain a little better:

We are trying to connect to Magento on Cloud from Oracle Data Integrator using REST Webservices or Jython and not having any luck so far.

Has anyone done that?

Thanks