How connect to database to extract data and write pandas dataframe

Question

I have to connect oracle database to extract data and write into pandas data frame.

All I have available with me is Hostname , Port, Service Name

import cx_Oracle
Hostname = 'XX.XX.X.XXX'
port = 1521
Service_Name = 'DPP2.kn.com'
dsn_tns = cx_Oracle.makedsn(Hostname, port, Service_Name)

connection = cx_Oracle.connect('BA', 'PASSWORD', dsn_tns)

Its not working.How to fix this

Have you installed the Instant client ( the oracle client driver) and set ORACLE_HOME to the appropriate path ? — Kaushik Nayak
– Kaushik Nayak, Commented Mar 30, 2019 at 17:36

Barbaros Özhan · Accepted Answer · 2019-03-30 15:23:37Z

1

You can use cx_Oracle.connect method as

dsn_tns = cx_Oracle.connect(username+"/"+password+"@"+ Hostname+":"+port+"/"+Service_Name)
cursor = dsn_tns.cursor()

and then retrieve data through cursor.execute()

edited Mar 30, 2019 at 15:23

answered Mar 30, 2019 at 15:17

Barbaros Özhan

65.9k11 gold badges36 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

pankaj Over a year ago

Getting database error DP1-1047 : Cannot locate a 64 bit Oracle client directory.

Barbaros Özhan Over a year ago

@pankaj the issue is obvious then ( 64-bit client needed )

Collectives™ on Stack Overflow

How connect to database to extract data and write pandas dataframe

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related