Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the driver beyond simple SELECT/INSERT/UPDATE/DELETE operations with Sage Intacct.
Stored procedures accept a list of parameters, perform their intended function, and then return, if applicable, any relevant response data from Sage Intacct, along with an indication of whether the procedure succeeded or failed.
CData JDBC Driver for Sage Intacct Stored Procedures
| Name | Description |
| CreateAttachment | Create an attachment. |
| CreateCustomReportSchema | Creates a schema file for the specified custom report. |
| CreateSchema | Creates a schema file for the specified table or view. |
| GetCustomFields | Retrieves a list of keys in an object. |
| GetDimensionRestrictedData | Lists the IDs of related dimensions that are the targets of to-many relationships from a single source dimension. |
| GetKeys | Retrieves a list of keys in an object. |
| GetRelationshipColumns | Sets relationship columns in Intacct. |
| SetRelationship | Sets relationship columns in Intacct. |
| UpdateAttachment | Updates the attachment Table. |