Related links: Systems Supported by Jedox Integrator
The first step of a Jedox Integrator project is always to specify the connections with a source or target system in order to import or export data.
The most important data outputs tend to come from relational databases, such as MySQL, in which transaction data are saved. Any established relational database system (RDBMS) can be connected to Jedox Integrator (ETL) as a source. The connection is done via a specific JDBC driver.
Database-specific options for the connection can be set by adding parameters to the table “Additional JDBC parameters”. They are added to the generated JDBC URL. Please refer to the documentation of the database vendor for a list of possible values.
In all file-based connection types (File, XmlFile and ExcelFile), the URL of the file in the Report Designer can be entered as a filename. So, to extract data from CSV, XML, or XLSX files, you can use the Import Wizard in the Report Designer for the upload. The URL target of the file can be copied from the Report Designer under Properties→Link. It must include the credentials.