SAP Knowledge Base Article - Preview

2699151 - SQL Server synonyms not importing in Data Services Designer

Symptom

  • 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.

Read more...

Environment

  • SAP Data Services
  • Microsoft SQL Server

Product

SAP Data Services 4.2

Keywords

KBA , EIM-DS-DES , Data Services User Interface/Designer , EIM-DS-EXE , Data Services 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 ONE Support launchpad (Login required).

Search for additional results

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