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?
Data Comparison Between ERP System and SALESFORCE.COM
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.
Base - Lining Product Catalog
Lets’s say there are 1000 products in the catalog and it is important to ensure that the metadata of this product catalog does not get accidentally modified. How would you do that?
- 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.
Metadata Comparison Within SALESFORCE.COM
Over a period of time, it is important to understand the changes to profiles, roles, access privileges etc in the Salesforce platform so that only the expected changes are going in with each internal release and nothing else is slipping through the cracks.
- 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.
Data Testing Within SALESFORCE.COM
ETL Validator be used to define rules on specific data elements: Example: Define a rule so that the percentage on a rebate is always less than 20% for a product.
