SAP Knowledge Base Article - Preview

2710323 - DCA error: Unable to create data table - SAP Information Steward 4.2


  • Data Cleansing Advisor error: "Unable to create data table"
  • "ERROR: Unable to access staging tables for cleanse operation. Additional information: Error executing data load job."
  • EIMAdaptiveProcessingServer log contains an ODBC connection error
  • EIMAPS log contains error: "||Unable to create data table. Additional information: Error creating datastore: Cannot open connection - openConnection remote error"
  • "SEVERE: Open connection remote error: ODBC call <SQLDriverConnect> to connect database <DCA> failed with error: <ODBC call <SQLDriverConnect> to connect database <DCA> failed with error: <[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified>."



  • SAP Information Steward 4.2
  • Data Cleansing Advisor
  • Supported Windows platform


SAP Data Services 4.2 ; SAP Information Steward 4.2


DCA, EIM APS, ODBC Driver Selector, SQL Anywhere, BOIS, IS , KBA , EIM-IS-DCA , Information Steward - Data Cleansing Advisor , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.