Using sync editor to call stored procedure in target system

Hello Experts,

Is it possible to configure a SQL or Oracle connector to call a stored procedure in the target system to do CRUD operations?

We don't have access to the target system tables directly, instead we have been given a stored procedure which will return the values we need. How can we invoke this and do a column mapping?

Thanks

Kin

Parents
  • Updating the data, CUD part of the operations, can be done using the data operations that can be configured for the connectors during the creation of the connection. If the data can only be read via the stored procedures, you need to use the native database connector for the generic ADO.NET provider, which allows you to define your own queries to fetch the data. The down-side is, that you need to provide the complete CUD code on your own for all operations.

Reply
  • Updating the data, CUD part of the operations, can be done using the data operations that can be configured for the connectors during the creation of the connection. If the data can only be read via the stored procedures, you need to use the native database connector for the generic ADO.NET provider, which allows you to define your own queries to fetch the data. The down-side is, that you need to provide the complete CUD code on your own for all operations.

Children
No Data