To extract data from SAP using TimeXtender, the best approach is to use Theobald Xtract Universal with their proven technology and performance. To get the data to TimeXtender's Operational Data Exchange (ODX) seamlessly and without data duplication, Xtract Universal provides http-json endpoints, and also metadata discovery endpoints.
To make the extractions created in Xtract Universal known to the ODX, RSD files are needed, that point ODX to the right URL, list the columns and data types available in each table.
This knowledge base article explains the whole setup process.
This RSD-generator helps to make the process of generating these RSD files easier - by reading the metadata provided by Xtract Universal and enhancing a given rsd template with the schema metadata.
From TimeXtender with 📈, 🧠 & ❤️
Your machine should have
- access to Xtract Universal (can be installed on the same machine, or on another reachable machine)
- At least one SAP source configured in Xtract Universal
- At least one extraction configured in Xtract Universal
- Python 3 installed
-
Download and extract this repository to a local folder (or use
git cloneto create a local copy) -
Open a command window in the folder
-
Create a Python environment
python -m venv .venv
-
Activate the Python environment
.\.venv\scripts\activate
-
Install required Python packages (
requests&python-dotenv).\.venv\scripts\pip install -r requirements.txt
-
Copy or rename
.env.exampleto.env -
Adjust parameters in
.envfile:XU_BASE_URL- point to the root endpoint of your Xtract Universal installationRSD_TARGET_FOLDER- point to the folder where your RSD files should be created
install.batwill cover steps 1-6, just execute it, and skip to step 7.
.\.venv\scripts\python.exe main.pyor alternatively execute run.bat in a command window within the folder.