My Oracle Support Banner

Can ODI Generate the DDLs For Salesforce Models? (Doc ID 2365270.1)

Last updated on OCTOBER 22, 2019

Applies to:

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


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(
  at oracle.odi.ui.framework.UIFramework.executeBackgroundTask(
  at com.sunopsis.graphical.dialog.SnpsDialogADHGenerateDDL.initialize(
  at com.sunopsis.graphical.dialog.SnpsDialogADHGenerateDDL.<init>(
  at oracle.odi.ui.action.SnpsPopUpActionADHGenerateDDL.actionPerformed(
  at oracle.odi.ui.SnpsActionControler.handleEvent(


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.