search cancel

Data model scan does not show relationship between the tables

book

Article ID: 243496

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We are trying to scan tables in SAP HANA DB using Broadcom TDM Portal.

Tables are getting scanned but relationship between the tables are not visible. We have confirmed with SAP that the tables have relationship with other tables. We also tried both Basic and Advanced scan but still the we are not able to see the related tables and columns.

Environment

Release : TDM 4.10

Component :

Database:   SAP HANA

Resolution

The issue is due to user privileges configured in connection profile. Make sure user has below permissions to access the table relationships during scanning.

Granted Roles: PUBLIC

Object Privileges: SAPHANADB (SELECT, INSERT, UPDATE, DELETE)