cancel
Showing results for 
Search instead for 
Did you mean: 

Pull data in SAP from External Oracle database

Former Member
0 Kudos

Dear Friends,

I have SAP ECC 6.0 , Oracle 10g on HP-UX 11iv2. Now I have another external Oracle 9i database.

I want to pull data from external database in our existing database.

Please help.

Regards

Ganesh Datt Tiwari

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Is it planned as a periodic job? Or once? You can use import/export procedure;

http://www.orafaq.com/wiki/Import_Export_FAQ

Or create a database link. Then select and insert into the table;

http://docs.oracle.com/cd/B12037_01/server.101/b10759/statements_5005.htm

Best regards,

Orkun Gedik

Former Member
0 Kudos

Hi Friends,

thanks for valuable reply.

I have created a link using t. code DBCO and made entry in tnsnames.ora file in dir /sapmnt/<SID>/profile/oracle/

but when i trying to test the connection then it is giving the error as below.

Testing a Database Connection Defined in DBCON

Could not open connection MYCON .

sql error 12,154 occured:

ORA-12154: TNS:could not resolve the connect identifier specified

Regards

Ganesh Datt Tiwari

Former Member
0 Kudos

Hi Tiwari,

>> ORA-12154: TNS:could not resolve the connect identifier specified

You need to add remote database to TNSNAMES.ORA configuration

Best regards,

Orkun Gedik

former_member204080
Active Contributor
0 Kudos

Hi,

See this note

Note 443867 - ORA-12154 Collective SAP note

former_member188883
Active Contributor
0 Kudos

Hi Ganesh,

Below is just a guideline

Using transaction SE11, create a table (ZTABLE) with the same fields as the table in the external database, make sure that the type and lengths of the fields are identical.

Using transaction SE11, create a view (ZTABLE_VIEW, projection view) using BASIS table ZTABLE

Using SQL>

create dblink REMOTE_DB as connect to remote_user identified by password; (database link created)

drop table ZTABLE; (table dropped)

create synonym ZTABLE for ZTABLE@REMOTE_DB; (synonym created)

Using transaction SE16 , type in ZTABLE_VIEW and hit RETURN

Enter value in key fields and hit execute. (displays rows from the remote table)

Regards,

Deepak Kori