Installing and updating the on-premise JDBC extractor
The JDBC extractor, available from the Celonis Platform Download Portal, allows you to connect to any SQL database. This extractor is regularly updated, requiring you to update to the latest version to ensure compatibility and take advantage of the latest enhancements and features.
System requirements and Java version
From version 2.80.1 of the JDBC extractor, you're required to upgrade your Java version to at least Java 17
You also should ensure that all system other requirements of the extractor server are fulfilled. For the complete requirements, see System requirements.
Downloading the latest JDBC extractor
The JDBC extractor is available to download from the Celonis Download portal for users with MANAGE DOWNLOAD PORTAL permissions in their Celonis Platform team.
With the necessary permissions, you can access the Download Portal by clicking Admin & Settings and then clicking Download Portal:
Once in the Download Portal, you'll find the latest versions of the JDBC extractor:
Updating the on-premise JDBC extractor
After ensuring you meet the latest system requirements and have downloaded the latest JDBC extractor, you can update this with the following steps:
If you've customized the JDBC extractor's YAML configuration file, proxy configuration file, or XML configuration file, save a copy of these files from the existing extractor directory.
YAML configuration: application-local.yml
Proxy configuration: Proxy.yml
XML configuration: CelonisJdbcExtractor.xml
In a sandbox environment, create a new directory and install the new version of the extractor package into it.
The package creates subdirectories and extracts the files from the jar file. It's important to do this in a new directory, rather than replacing the jar file in the existing directory, so that the new package can fully validate that it's been correctly installed.
If updating from version earlier than 2.82.0: Transfer your customizations for the file CelonisJdbcExtractor.xml to the CelonisJdbcExtractor.xml file supplied with the new version of the extractor package. You need to use the updated version of this file from 2.82.0 or later.
If updating from version 2.82.0 or later: Replace the CelonisJdbcExtractor.xml file in your new directory with your customized version.
Replace the following files in your new directory:
YAML configuration: application-local.yml
Proxy configuration: Proxy.yml
You don't need to retain the updated versions of these files.
Start the new version of the extractor following the instructions in "Step D: Run The Extractor" in How do I set up an on-premise Extractor?
Verify that the extractor is working correctly in your sandbox environment. If yes, follow the above steps to install the extractor to your production environment.
Once the updated version of the extractor is working in your production environment, stop and uninstall the older version of the extractor.
JDBC extractor change history
Version | Release date | Changes |
---|---|---|
2.94.0 | 2024-04-08 |
|
2.93.2 | 2024-03-25 |
|
2.92.1 | 2024-03-06 |
|
2.91.5 | 2024-02-16 |
|
2.90.0 | 2024-01-26 |
|
2.89.0 | 2024-01-11 |
|
2.88.1 | 2023-12-13 |
|
2.87.0 | 2023-10-26 |
|
2.86.0 | 2023-09-22 |
|
2.85.0 (2023-09-01) | 2023-09-01 |
|
2.84.0 | 2023-08-10 |
|
2.83.0 | 2023-06-21 |
|
2.82.0 and 2.80.1 | 2023-08-10 |
|
2.77.0 | 2023-02-27 |
|
2.76.0 | 2023-02-15 |
|
2.75.0 | 2023-02-01 |
|
2.71.0 | 2022-11-25 |
|
2.70.0 | 2022-11-16 |
|
2.69.0 | 2022-10-27 |
|
2.67.0 | 2022-09-28 |
|
2.66.0 | 2022-09-15 |
|
2.65.0 | 2022-09-09 |
|
2.64.0 | 2022-08-24 |
|
2.63.0 | 2022-06-30 |
|
2.62.0 | 2022-06-30 |
|
2.61.0 | 2022-06-30 |
|
2.60.0 | 2022-06-16 | Minor improvements and fixes. |
2.59.0 | 2022-06-02 |
|
2.57.0 | 2022-05-05 |
|
2.56.0 | 2022-05-05 |
|
2.55.0 | 2022-05-05 |
|
2.54.0 | 2022-05-05 |
|
2.51.0 | 2022-05-05 |
|
2.50.0 | 2022-05-05 |
|
2.49.0 | 2022-05-05 |
|