- Handle Response Interface after Executing a Stored-Procedure with data returned in SQLServer
- Handle Response Inbound Interface for file adapter
- Sort file based on CreateDate/filename with ASC/DES
- Support Integration InboundV3 with bulk mode
- Restart Agent Service from Agent Control Board
- Support integrate per InterfaceGroup
- Support outbound using MessageType for the JDBC adapter
- Enhance InboundV3 to support File, FTP, and JDBC adapter
- Change SObject for Updating LastNext_RunDate to avoid the issue that unable to lock row while updating interface at the same time (supports Skyvva v2.45)
- Pushing log file to Salesforce via using Agent Control board
- Creating CA-Signed certificate for Agent Service (https)
Handle Response Interface after Executing a Stored-Procedure with data returned in SQLServer #
The agent can handle the response Interface after Executing a stored procedure with SQLServer. For inbound we use stored procedure to read data from the database and push it to SKYVVA and for outbound, we read data from salesforce and pass it to the stored procedure so the stored procedure can do business logic with that data.
- Inbound scenario: We use stored procedures to read data from the database and push it to SKYVVA.
- Outbound scenario: We read data from Salesforce and pass it to the stored procedure. The stored procedure can do business logic with that data.
- SQLServer procedure inbound/outbound with Agent Inbound we use stored procedure to read data from the SQLServer database and do the integration. Outbound we read data from salesforce and pass it to SQLServer stored procedure so the stored procedure can do business logic with that data.
Handle Response Inbound Interface for file adapter #
As per the feature, the user experienced updating a sObject after exporting data from SF.
This feature experiences to handle a response interface to update the SObject. But for the file adapter, we don’t know what data should return back unlike the JDBC adapter which we return data via a stored procedure. So the idea is just to return back only the ID of SObject and another field we will use the formula in the mapping tool to set its value.
Sort file based on CreateDate/filename with ASC/DES #
An agent can process an order by file name ascending with an old version. And now we have a new feature it can support CreateDate or FileName with ascending or descending. The agent uses adapter properties to store configuration with an adapter-type File.
Support Integration InboundV3 with bulk mode #
- The agent can send Hierarchical XML data to salesforce in real-time the data into the Salesforce database immediately after the agent sends it.
- Now we support function processing with Agent to send Hierarchical XML data to store in Bulk Control board, with InboundV3 Integration.
- All data will be stored in the Bulk control board after agents send data with InboundV3 Integration.