Leverage My Child Care Account (MCCA)
The current process to synchronize CSIS II with the Families portal platform can be leveraged to upload client information to Salesforce. Fee Subsidy applications are entered online, vetted by the A&E staff then accepted into the CSIS II system. Included in the online application is client, child and household information, all of which are needed in the initial phase of the Service Console.
The Oracle Streams synchronization events are monitored and can spawn a restful call to Salesforce when client information is changed.
Possible Implementations
Polling
Poll for changes to the client information
Real time Trigger
Use the database trigger to invoke a RESTful call to the Salesforce mediation service.
Proposed Implementation
The Polling approach is favoured over the Real Time Trigger.
Apache Camel
Apache Camel is an open source integration framework based on known Enterprise Integration Patterns with powerful bean integration. Apache Camel can be used to implement a Microservices Architecture enabling the creation of Smart Endpoints communicating through Dumb Pipes.
Salesforce Component
Apache Camel provides over 300 components to help create the Smart Endpoints. Among these components is the Salesforce Component that simplifies Java coding to communicate with a Salesforce Org.
The Salesforce Camel Component offers three methods for a consumer of the services to authenticate with the org. This implementation will be using the JSON Web Token (JWT) a bearer token implementation requiring a self signed key pair with the public key registered with Salesforce.
JPA / JDBC Component
These Apache Camel components can be used to poll the legacy data source for changes to data of interest.
JWT Generator Lib:
https://github.com/auth0/java-jwt
Salesforce JWT Oauth Flow:
https://help.salesforce.com/articleView?id=remoteaccess_oauth_jwt_flow.htm&type=5
JWT Standard:
Salesforce REST API Documentation:
https://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/quickstart.htm