Salesforce Integration Testing
Automation Integration Testing of Salesforce Data
How does ETL Validator help with Integration Testing of Salesforce.com?
- 100% Test Coverage
- Cost Reduction
- Repeatable
- Faster Results
- Easy Connectivity
How does ETL Validator access data from Salesforce.com?
- JDBC or ODBC Drivers (Simba, CDATA, Progress)
- REST API
- SOAP Services
How to compare data between Oracle ERP and Salesforce.com?
JDBC or ODBC Driver
ETL Validator already supports JDBC driver from Simba for Salesforce. Any of the test cases (eg. Query Compare) can be used to compare data between Oracle and Salesforce. For other JDBC drivers, ETL Validator provides a Generic JDBC driver option.
REST API / JSON Data
Apache Drill can be used to query on JSON data. ETL Validator supports Apache Drill as a data source.
SOAP Services
ETL Validator supports SOAP Services as a data source. It also has a Web Service test plan for extracting data from the SOAP services for the purpose of testing and data comparison with data in Oracle database.
What kind of Use cases can be tested?
Consider a typical integration between Oracle ERP and Salesforce. Accounts and Orders need to be in sync all the time for complete visibility.
Typically, the objects are involved are – Account, Product, Order and Order Line Item tables. On a regular basis, few questions emerge:
- Did all the Accounts from ERP app make it to the Salesforce app?
- What is the best way to compare the counts?
- Are all the records between Salesforce and ERP system matching?
- Is referential integrity among accounts, orders, order line items intact in Salesforce?
With ETL Validator, you can easily execute the above tests in no time.
- In ETL Validator, you can baseline a table.
- Run tests on an ongoing basis to ensure that the data accidentally does not get modified.
- If it does, then the platform can send out notifications with the records that do not have data as expected.
- Using ETL Validator, take a baseline of the object metadata.
- Compare the same over time.
- If there are differences, ETL Validator sends out notifications & alerts administrators of unexpected changes.
