Difference between revisions of "QPR Suite ETL Task Workbench (accelerator)"
| Line 25: | Line 25: | ||
[[node_QPR_Suite_Accelerators|To accelerators main page]] | [[node_QPR_Suite_Accelerators|To accelerators main page]] | ||
| − | * [[Image:package-x-generic.png]][ | + | * [[Image:package-x-generic.png]][https://files.qpr.com/qprsuite/QPR%20Suite%20ETL%20Task%20Workbench%201.4.0.zip QPR Suite ETL Task Workbench 1.4.0.zip] |
| − | * [[Image:application-pdf.png]][ | + | * [[Image:application-pdf.png]][https://files.qpr.com/qprsuite/QPR%20Suite%20ETL%20Task%20Workbench.pdf QPR Suite ETL Task Workbench.pdf] |
| − | * [[Image:application-pdf.png]][ | + | * [[Image:application-pdf.png]][https://files.qpr.com/qprsuite/QPR%20Web%20Services%20Extensions%20Expression%20Language.pdf QPR Web Services Extensions Expression Language.pdf] |
Latest revision as of 13:47, 14 March 2022
QPR Suite ETL Task Workbench (accelerator)
28.01.2019 - 12:33
Disclaimer: Please note that QPR Accelerators are not supported by QPR Customer Care and are provided "as is" without any express or implied warranty.
Overview: QPR Suite ETL Task Workbench is a general purpose tool for integrations where data is extracted from or loaded to a QPR Suite environment. The tool has variety of use cases, one of which is transferring data between QPR EA/PD and QPR Metrics.
QPR Suite ETL Task Workbench can be configured to use both QPR Web Services and QPR API interfaces for extracting and loading data. The platform also includes an expression engine to enable more flexible data transformations.
The tool implements ETL (extract, transform, load) process as follows:
- Extract is performed using QPR Web Services QueryObjects.
- Transform is performed using expressions.
- Load is performed using QPR Web Services CreateObject, SetAttribute and DeleteObject.
Latest version: 1.4.0 (2016-09-26)
Compatible with: QPR Suite 2016.1, QPR Suite 2015.1, QPR Suite 2014.1, QPR Suite 2012.2, QPR Suite 2012.1
Productization level: medium
Required expertise for building integrations: Editing XML, Working with EA/PD metamodel, Working with Metrics model, Understanding QPR Web Services, Using QPR API (more information)
