Salesforce Integration Testing

Automation Integration Testing of Salesforce Data

How does ETL Validator help with Integration Testing of

How does ETL Validator access data from

How to compare data between Oracle ERP and

  • 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:

  1. Did all the Accounts from ERP app make it to the Salesforce app?
  2. What is the best way to compare the counts?
  3. Are all the records between Salesforce and ERP system matching?
  4. 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.

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?
  1. In ETL Validator, you can baseline a table.
  2. Run tests on an ongoing basis to ensure that the data accidentally does not get modified.
  3. If it does, then the platform can send out notifications with the records that do not have data as expected.
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.
  1. Using ETL Validator, take a baseline of the object metadata.
  2. Compare the same over time.
  3. If there are differences, ETL Validator sends out notifications & alerts administrators of unexpected changes.
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.

ETL Validator Resources

Try ETL Validator free for 30 days or contact us for demo​.
Shopping Basket