IMPORTANT: When creating or editing queries, the performance of SAP Connector highly depends on the efficiencies of your underlying tables in your SAP environment.
After you have linked your external database connection, use these steps to create a new query:
-
On the SAP Datasphere page, use the Connection drop-down menu to select the connection you want to query from.
-
Click the Create button.
-
In the Create Query page, select either:
-
Query Builder (Default): Choose this option to be guided through your query creation. See Query Builder.
-
Manual Query: Choose this option to write your own SQL query. See Manual Query.
NOTE: The Create, Copy, Delete, and Manage Objects buttons will be unavailable during this process.
-
