Running Datahub Import Manually

Running Datahub Import.
After you finish installation of Datahub. You will need to set up importer settings.

1. Setup the importer settings. Navigate to the Datahub directory:

This is a default directory if you have specified another directory you will need to open it.
You should see the following list of files:

1. Run DSIConfigurator, you will be presented with the following window:

1: IQsonar DB connection details.
2: Datahub Staging DB connection details.
3: Datahub EDW DB connection details.
You must use integrated authentication in order for Datahub import to complete successfully.

1. Once done save the configuration file.

1. You can now run the importer.

To run the importer you will need to use CMD command line interface as an Administrator or a User that has local Administrator privileges.

1. Using CD command navigate to the Datahub directory.

Run the following command:
DataSetImporter.exe config.xml
Where config.xml is the name of the configuration file you have saved earlier.
Once CMD is finished. Check DataSetImporter.txt for Errors this is a log file and should be used to verify dataset import is complete.

Manual import:
In case you need to run dataset importer manually you will need to log in to the DB with Datahub user level of privileges or higher.

Navigate to the Integrated Services Catalogs and run the packages below
By right clicking on individual packages and selecting Execute option. You will need to run packages one at the time, you will need to allow processing of each package to complete before moving onto a next one.

The order of execution is crucially important as they feed one into another. The order is as follows:

1. 2.14 to Staging
2. Staging
3. WSToEDW
4. DerivedSoftware
5. PostImportProcessing (You will need to run all the packages in this section top to bottom )