SAP Knowledge Base Article - Preview

1596595 - How to change schema of SQL Transform in Data Services

Symptom

  • You need to send the SQL in your SQL Transform to a different schema then what the Datastore points to
  • Your Datastore may have 'Alias' set up but this not affecting which schema the SQL transform sends it's query to - Alias works only for source tables
  • The SQL in your SQL Transform does not contain any references to schema / table owner


Read more...

Environment

  • Data Services
  • Oracle

Product

SAP Data Services 4.0 ; SAP Data Services 4.1 ; SAP Data Services XI 3.0 ; SAP Data Services XI 3.1 ; SAP Data Services XI 3.2

Keywords

BODS, BODI, DS, DSXI, Edge , KBA , EIM-DS , Data Services , How To

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.