Symptom
Existing table/view not found when creating a Data Flow. (e.g. Technical)
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
SAP Datasphere
Reproducing the Issue
- Create a new Data Flow in Data Builder.
- Select Source tab.
- Enter <Table/View name> in Search, 'No data' appears as a result.
Cause
To prevent performance issues, only the first 100 entries can be listed under connections.
Resolution
To import the existing table/view, please find these on 'Import Objects from Connection' page
- Under Connections, click "Import from Connections".
- On the 'Import Objects from Connection' page, select the connection from the first step and enter the name of the table/view.(e.g. Technical)
- Select the expected table/view and click the Next button. Then click "Add Selection" to finish the import.
Keywords
KBA , DS-DI-DF , Data Flows , Problem
Product
SAP Datasphere all versions