Other Tools

CopyStorm includes a number of useful tools that can be found under the “Tools” menu in the top-left corner of the application GUI.

   

The following tools are included:

  • SOQL Query Tool (Salesforce)
  • SQL Query Tool (Database)
  • Skipped Record Log Explorer

SOQL Query Tool (Salesforce)

The SOQL Query Tool provides a convenient, in-app interface for running SOQL queries against the target Salesforce org specified on the left side of the “Main” tab of CopyStorm. To use this tool, CopyStorm must connect to Salesforce, so the Salesforce credentials specified must be valid (use the “Test Salesforce Connection” button to validate).

To use the tool, simply enter a valid SOQL query into the white text-area and click the “Execute SOQL” button. The results of the query will be displayed below.

   

SQL Query Tool (Database)

The SQL Query Tool provides a convenient, in-app interface for running SQL queries against the target database specified on the right side of the “Main” tab of CopyStorm. To use this tool, CopyStorm must connect to the database, so the database credentials specified must be valid (use the “Test Database Connection” button to validate).

To use the tool, simply enter a valid SQL query into the white text-area and click the “Execute SQL” button. The results of the query will be displayed below.

   

Skipped Record Log Explorer

The Skipped Record Log Explorer provides a convenient interface for exploring and analyzing the reports recorded by CopyStorm when a record has been skipped during a job due to an error caused by the Salesforce platform. Errors that are reported by this feature include:

  • Base64ReadErrors (potential file body corruption)
  • DescribeSObjectErrors (potential metadata corruption).

The top window of the interface contains a filterable search window for each skipped record, and the bottom window provides all details recorded by CopyStorm when the record was skipped: