To extract tabular data from SAP® Business Warehouse (BW) based on a multidimensional expressions (MDX) query, add a step with an SAP Business Warehouse connection command.
To enable these commands, an IT admin first sets up an RFC connection, creates an SAP Business Warehouse connection and configures its credentials and properties:
|Server Hostname||Enter the IP address or hostname of the SAP Netweaver instance, such as
|Client||Enter the client ID to use for the RFC connection, such as
|Instance No.||Enter the instance number defined in the RFC connection|
|Username||Enter the username to authenticate with|
|Password||Enter the password for the Username input|
|SAP Jco Installation Folder||Enter the path to the SAP Java Connector (Jco) installation, such as
Note: All sensitive credentials are automatically encrypted and stored at 2,048-bit encryption.
Execute MDX Query
Executes an MDX query against SAP BW, and extracts the data to a comma-separated values (CSV) format
|Query||Enter the MDX query to execute|
|Query Results (CSV)||File|
|1||Error||There was an error during execution|
|2||Error||Unable to authenticate with the SAP server|