Skip to Content
0
Former Member
Jun 26, 2009 at 06:49 AM

Data services connectivity with Oracle 8i database

77 Views

Query 1:

We are using Data services XI R3 for pulling data from Oracle 8i data soure to Oracle 10g target.

Our repository is also a 10g database.

We created a datastore for 8i source and tried to import the table.

Below is the error that we get when try to import the table:

Error: Cannot import metadata.

Oracle <....> error message for operation <OCIStmtExecute> : <ORA-00904: Invalid column name>..(BODI-1112338)

While creating datastore, we entered database type as Oracle.

We were able to import the table with same 8i source , target and repository of 10g version by using Data Integrator XI R2 tool but when we try the same thing with Data services, we are getting this error.

Any other alternative other than using System DSN?

Query 2:

Also,is there any performance impact if we use ODBC System DSN name as the data source instead of Oracle while creating data store in Data services XI R3?

We have used DSN since we were not able to import table from Oracle 7 and 8i databases(source) into repository (Oracle 10g) if we give Oracle as the data source. Target database is also Oracle 10g database.

Edited by: Amardeep Pandey on Jun 26, 2009 8:51 AM