Cobra Help System

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

File Restore with Bulk Data Loader

When restoring projects with a very large time-phased data, you can run the Restore process with the Bulk Data Loader method to run the process much more quickly.

Note: Previously, the Oracle SQL Loader method was configurable using the legacy configuration file (cobra.process.cfg). Beginning with Cobra 8.5, Oracle SQL Loader is called Bulk Data Loader and can be configured through the Application Preferences dialog box and the Restore API process.

Restore Using Bulk Data Loader

When using the Restore process with the Bulk Data Loader method, Cobra uses the normal Restore process in restoring all data except the time-phased data and the Bulk Data Loader method in restoring time-phased data for TPHASE, COSTELEM, and BASEHIST tables on an Oracle database.

To use the Bulk Data Loader method, you must define UseBulkDataLoader=1. To run the Bulk Data Loader method automatically, you must define BulkDataLoaderAutoRun=1.

Note: Use the Advanced tab of the Application Preferences dialog box to define and configure these settings. For more information on settings that you can configure for the Bulk Data Loader method, see Advanced Settings

When you restore a single project through the Cobra application, you must select the Use bulk data loader checkbox in the Select Files to Restore dialog box. If this checkbox is cleared, Cobra will proceed with the normal Restore process.

When you restore multiple projects through the Cobra application, Cobra checks the UseBulkDataLoader setting to determine whether the Bulk Data Loader method will be used or not when running the Restore process.

Using Bulk Data Loader with BulkDataLoaderAutoRun=1

When BulkDataLoaderAutoRun=1, you do not need to perform additional steps.

Using Bulk Data Loader with BulkDataLoaderAutoRun=0

When BulkDataLoaderAutoRun=0, you must perform additional steps on the generated files to load time-phased data completely.

  • Make sure the Bulk Data Loader statement is correct in the generated CostelemLoad.bat, TphaseLoad.bat, and BasehistLoad.bat files.
  • Replace uid/pwd@instance with the appropriate user ID, password, and Oracle instance ID so that Bulk Data Loader can load time-phased data.
    • Cobra does not put the uid/password credentials in the batch files.
    • Enclose the password with \" if you are using special characters. For example, a password of p@ssword should be \"p@ssword\".
  • Delete angled brackets (<>) around the string if present.
  • The batch file assumes that the Oracle SQL loader executable file (sqlldr.exe) path is found in the Windows path. If not, include the full path in front of Bulk Data Loader reference.