Can ODI Generate the DDLs For Salesforce Models?

(Doc ID 2365270.1)

Last updated on JUNE 11, 2018

Applies to:

Oracle Data Integrator - Version 12.2.1.2.6 and later
Information in this document applies to any platform.

Goal

Does the Salesforce adapter support the creation of Data Definition Languages (DDLs) from Oracle Data Integrator (ODI) Studio?

When attempting to create a DDL from a Salesforce Model, the following error occurs:

ODI-26184: SQL error occurred. See error details for more information.

java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: [FMWGEN][SForce JDBC Driver][SForce]Unexpected token: \ in statement [select\n    c.constraint_name    AK_NAME, \n    cc.column_name    COLUMN_NAME, \n    cc.position        \nfrom\n    all_constraints c, \n    all_cons_columns cc \nwhere\n    c.constraint_type='U' \nand    c.owner=? \nand    c.table_name=? \nand    c.owner=cc.owner \nand    c.constraint_name=cc.constraint_name \norder by 1, 3]
  at oracle.odi.ui.framework.adapter.DefaultAdapter.executeBackgroundTask(DefaultAdapter.java:636)
  at oracle.odi.ui.framework.UIFramework.executeBackgroundTask(UIFramework.java:452)
  at com.sunopsis.graphical.dialog.SnpsDialogADHGenerateDDL.initialize(SnpsDialogADHGenerateDDL.java:341)
  at com.sunopsis.graphical.dialog.SnpsDialogADHGenerateDDL.<init>(SnpsDialogADHGenerateDDL.java:140)
  at oracle.odi.ui.action.SnpsPopUpActionADHGenerateDDL.actionPerformed(SnpsPopUpActionADHGenerateDDL.java:64)
  at oracle.odi.ui.SnpsActionControler.handleEvent(SnpsActionControler.java:94)
  ...

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms