SAP Knowledge Base Article - Preview

3668516 - "The user does not have any access to database" error when importing a View/Table from Teradata datastore - SAP Data Services

Symptom

Receiving error when trying to import a Table or View from Teradata datastore even if it works from ODBC Data Source test connection:

  • Error: Cannot import metadata.
    ODBC data source <DATA SOURCE> error message for operation
    SQLTables: <[Teradata][ODBC Teradata Driver] [Teradata Database](-3524)The user does not have any access to database <USER>.>. (BODI-1112338)

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."  


Read more...

Environment

  • SAP Data Services 4.x
  • Teradata

Product

SAP Data Services 2025 ; SAP Data Services 4.2 ; SAP Data Services 4.3

Keywords

BODS, DS, DB, allow, grant, configuration, migrating, metadata, connect, CON, communication, schema, credentials , KBA , EIM-DS-CON , Connectivity , 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.