With a forthcoming release, you'll be able to write or generate SQL queries for JDBC data extractions using the new in-built Extractions Editor and AI Assistant. These enhanced features will allow you to use your source system specific SQL functions and JOINS, making it easier for you to extract your data into the Celonis Platform.
In addition to generating extraction queries, the AI Assistant will also help validate queries for you.
For further information, see: Extractions Editor and AI Assistant overview.
Using the JDBC extractor?
If you're currently connecting to your source system using the JDBC extractor, you must update the extractor to version 3.0.0 in order to use the Extractions Editor and AI Assistant.
For more information about installing and updating the JDBC extractor to version 3.0.0, see: Updating the on-premise JDBC extractor.