Description
We’re excited to announce an advanced enhancement for JDBC integrations the rollout of Advanced Low-Code Provisioning. This release makes SailPoint’s JDBC connector provisioning rule configurations more accessible and user-friendly to organizations looking to integrate databases without deep Java expertise.
What is the Problem?
JDBC is among the most adopted connectors for integrating with various databases. However, configuring provisioning rules requires Java expertise and sophisticated customization. Customers had to manually write Java code, define SQL, and build custom provisioning rules to support basic operations across Oracle, MySQL, MSSQL, and other databases.
As customers shift to configuration-centric teams, the need for a simplified, scalable, low-code solution becomes clear.
What is the Solution?
We’re removing complexity by introducing:
UI-Based Configuration
You can now configure key JDBC provisioning operations directly from the UI, while completely avoiding writing Java code
Users can:
- Define table names, columns, and SQL logic through a guided UI.
- Configure provisioning rules visually.
- Support both single and multi-query execution, and stored procedures with input parameters.
Note: To use this feature, ensure Configure Provisioning Operations is enabled in the source configuration page.
Low-Code Provisioning Rules
The new low-code interface supports sql query configuration to achieve:
- Create, Enable, Disable, Update & Unlock Account
- Entitlement Configuration
- Attribute configurtaion
- Single or multiple SQL query execution
- Stored procedure calls
- Inline variable substitution
Example:
UPDATE users SET first_name = $plan.firstName.string$ WHERE id = $response.id.int$
This model allows full flexibility while maintaining a user-friendly, no-code interface that ensures control, reusability, and security.
Availability: Release Information & Documentation
The new features are available in ISC JDBC connector and are applicable to both existing sources and new integrations.