Oracle to PostgreSQL.

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
rkashyap
Premium Member
Premium Member
Posts: 532
Joined: Fri Dec 02, 2011 12:02 pm
Location: Richmond VA

Oracle to PostgreSQL.

Post by rkashyap »

We are using Datastage 11.51 to copy tables over from Oracle 12G to PostgreSQL on GCP platform. IBM's ODBC driver is being used to connect to PostgreSQL.

[img]Oracle%20Connector%20---->%20ODBC%20/%20PostgreSQL[/img]

Table metadata is populated in Column definition tab. Unfortunately table creation is failing on all numeric columns.

ODBC_Connector_1: Error while generating the create table statement at run time. Could not obtain data type information from the ODBC driver for the column: ID. (CC_OdbcAdapter::generateCreateStatement, file CC_OdbcAdapter.cpp, line 1,069)

Can you please help?.
rkashyap
Premium Member
Premium Member
Posts: 532
Joined: Fri Dec 02, 2011 12:02 pm
Location: Richmond VA

Post by rkashyap »

Issue has been identified as a product bug and sent to engineering.
Post Reply