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.
From version 2.80.1 of the JDBC extractor, you're required to upgrade your Java version to at least Java 17.
Also ensure that all other system requirements of the extractor server are fulfilled. For the complete requirements, see System requirements.
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:
Celonis only provides fixes for the most recent version of the on-premise JDBC extractor. If you're running a JDBC extractor that's not the most recent version and you raise a support ticket, we'll check whether the bug or issue still exists in the most recent version. If it does, we’ll fix it in that version. In any case, you'll need to upgrade to the most recent version to get the fix.
Older versions of the JDBC extractor won't stop working - you can carry on using them until you need support, at which time you'll need to upgrade to get the bug fixes. We recommend you update the JDBC Extractor at least every quarter, even if you don't experience any issues, to get the latest capabilities and any fixes for security vulnerabilities.
On the download portal under the JDBC Extractor section, you can see the release date of the most recent on-premise JDBC extractor version at the start of the package name, which is in this format:
<YYYY-MM-DD>-package-name-<major version>.<minor version>.<patch version>
For example, the release date for the version shown here is 6 March 2024:
2024-03-06-dockerized-package-jdbc-2.92.1
You can confirm the release date of your currently installed JDBC extractor version by going to Admin & Settings > Uplink Integrations. The release date is shown in the Connector Version field for the “Cleo Uplink” connector.
If you have any questions or need help, talk to your Celonis point of contact, or find how to get in touch with us: Contacting Support.
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 a 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 it is, 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 |
---|---|---|
3.0.0 | 2024-10-30 |
|
2.106.2 | 2024-10-16 |
|
2.105.0 | 2024-09-30 |
|
2.104.1 | 2024-09-05 |
|
2.103.0 | 2024-08-23 |
|
2.102.1 | 2024-08-08 |
|
2.101.5 | 2024-07-23 |
|
2.100.0 | 2024-07-05 |
|
2.99.0 | 2024-06-19 |
|
2.98.5 | 2024-06-10 |
|
2.97.1 | 2024-05-29 |
|
2.96.1 | 2024-05-14 |
|
2.95.2 | 2024-05-03 |
|
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 |
|