SAP Knowledge Base Article - Preview

2699151 - SQL Server synonyms not importing in Data Services Designer


  • When you try to import a synonym from a Microsoft SQL Server datastore, the table does not appear in the list of available imports
  • Unable to reference a Synonym using an SQL Transform
  • Cannot see SQL Server synonyms in the list of tables.
  • Cannot find the SQL Server synonym when searching the external objects of the datastore.



  • SAP Data Services
  • Microsoft SQL Server


SAP Data Services 4.2


KBA , EIM-DS-DES , User Interface/Designer , EIM-DS-EXE , Job Execution , Product Enhancement

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.