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

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. You can choose to either include or exclude Deleted and Archived records in the results with the “Include Deleted And Archived Records” checkbox. The results of the query will be displayed below.

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.

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: