I would like to connect to multiple databases in oracle

Question

How can I connect to multiple database in oracle using python library ?

Answer 1

Hey Radhika,

To communicate any database with Python program, you required a connector which is nothing but the cx_Oracle module.

• To installing cx_Oracle : 

1. With this command, you can install the cx_Oracle package, but it is required to install the Oracle database first in your PC..

pip install cx_Oracle

• Now you need to use some modules for connection:

1. Import specific database module- import cx_Oracle
2. Connect()  :- Now establish a connection between the Python program and the Oracle database by using connect() function.​

                  connect = cx_Oracle.connect('username/password@localhost')

       3. Cursor(): To execute SQL query and to provide a result, some special object required is nothing but cursor() object

                  cursor = cx_Oracle.cursor()

For more and clear cut information you can go through this https://datatofish.com/how-to-connect-python-to-an-oracle-database-using-cx_oracle/ I hope this will help.

Comments

Thanks Gitika. How about multiple DB's ? What is the approach to connect to multiple databases which are on multiple servers ?

Thanks,

Radhika.