Apache Ignite is an in-memory computing platform for transactional, analytical, and streaming workloads delivering in-memory speeds at petabyte scale. It can be used as an in-memory cache or as an in-memory database but that doesn’t mean everything has to move to Ignite. Users can keep their existing databases and deploy Apache Ignite on top of these data sources as a data caching layer that enables users to keep frequently accessed data in memory. We can also cache SaaS data sources like Salesforc or Oracle Sales Cloud for enabling high performance data processing, analytics and write to the source if we update the in-memory cache. Apache Ignite uses JDBC to integrate to relational databases and we can use this integration to cache our data with the help of Progress DataDirect’s JDBC Connector for Salesforce.
To get started, we will walk through how to connect and cache Salesforce data in Apache Ignite using the Progress DataDirect Connector for Salesforce.
- Open the downloaded project in Intellij or Eclipse.
- Copy the Progress DataDirect Salesforce connector (sforce.jar) to ImportedCluster-project/jdbc-drivers/ and Add it as a library to the project.
- Start Ignite Server nodes by running the ServerNodeSpringStartUp
- The below message appears from the server when it is ready.
- Go to the resources folder in the project, open secret.properties and configure the JDBC URL, Username and Password for the Salesforce account.
- Now load the Salesforce data into cache by running the LoadCache class in the project. The below message will appear after the data is loaded to cache.
- We can now go to web console and query the cache or query and modify the cache from our applications.
We hope this tutorial helped import your Salesforce data to Apache Ignite cache for data processing, transactions, and analytics. Please contact us with any questions and we will be happy to help.