Skip to content

[Feature] Add VSCode Extension Support for RDBMS Connector #995

@imedyaosandi

Description

@imedyaosandi

Is your feature request related to a problem? Please describe.

This PR introduces the necessary VSCode extension support for the new Micro Integrator (MI) RDBMS Connector. Currently, integrating MI with relational databases using mediators like DB Lookup/Report is often cumbersome, lacks intuitiveness, requires manual handling of security aspects (like SQL injection), and involves complex transaction management.

Describe the solution you'd like

  • Provide support for the new MI RDBMS Connector in the VSCode extension.
  • Improve the developer experience by simplifying the configuration of database connections and operations.
  • DB driver jar selection option for the user.
  • Enable dynamic fetching of database metadata (tables, columns, procedures) in 'Online' mode to reduce manual input and errors and cumbersome configuration.
  • Simplify the transaction management process by providing built-in operations for beginTransaction, commit, and rollback that allows the user to group multiple DB operations within a transaction blocks visually.

Describe alternatives you've considered

No response

Additional Context

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions