To enter data in BlueDolphin you can use the DataCollector Front-end and Service applications. This article contains a .zip file containing the software. See the bottom of this article.
DataCollection Windows Service
The .zip file contains two MSI files:
- DataCollection Windows Service.msi
- DataCollection Frontend.msi
The "DataCollection Windows Service.msi" should be installed on a Windows machine that can connect to the data you would like to upload to BlueDolphin. As BlueDolphin is hosted in Microsoft Azure (a cloud provider), the machine should also have access to the internet. Specifically, the application connects to:
- https://api2.bluedolphin.valueblue.nl - tcp/443
- https://bdstorageprd.blob.core.windows.net - tcp/443
And ofcourse the application should be able to connect to various sources.
The MSI will install the application and a Windows Service,
After you have installed the Windows Service, you need to open the file DataCollection.Agent.Host.WindowsService.exe.config in the default installation folder (%PROGRAMFILESFOLDER%\ValueBlue BV\DataCollection Service). In this file you will configure the properties needed to connect to your BlueDolphin instance. The values you will need can be found in BlueDolphin under Admin\General.
This can be found in BlueDolphin. Go to Admin and choose "General" in the menu on the left. There you will find the "DataCollection API Key". Use that value in here.
This can be found in BlueDolphin. Go to Admin and choose "General" in the menu on the left. There you will find "Database". Use that value in here.
When your organisation uses a Proxy server to connect to the internet, the following configuration properties will need to be filled in:
|PresentationServiceUseProxy||true / false||True if you use a proxy server|
|PresentationServiceProxyAddress||Proxy server address|
|PresentationServiceProxy UseCustomCredentials||true / false||True if you need to specify credentials|
|PresentationServiceProxyUsername||Proxy server user name. Syntax: %domain%\%username%|
|PresentationServiceProxyPassword||Proxy server password|
After you have completed the configuration, you can start the service. In the case that the service runs under a service account, and the service does not start, please check the Windows Event Viewer for the following error:
"Service cannot be started. System.ServiceModel.AddressAccessDeniedException: HTTP could not register URL http://+:8000/DataCollectionAgentService/. Your process does not have access rights to this namespace (see http://go.microsoft.com/fwlink/?LinkId=70353 for details). ---> System.Net.HttpListenerException: Access is denied"
When this is the case, please run the following command (as an administrator):
- netsh http add urlacl url=http://+:8000/DataCollectionAgentService user=DOMAIN\USERNAME
Please replace DOMAIN and USERNAME with the appriopriate values
After you have installed the Windows Service and have started the service, you can start the installation for the Front-end. You can install this using the DataCollection Frontend.msi. Using the DataCollection frontend, you can configure the data going in and out of BlueDolphin
Data from BlueDolphin (Export)
Instead of importing data to Bluedolphin, you can also export data from Bluedolphin. Chose the following option: "from BlueDolphin (Export)". When you want to add a new export you chose "Add". The following screen will appear:
You can give a name to the export item (This is how the item will be visible in the tool), After this you select the report. The reports you want to export have to be placed in the BI environment in the map "Dataset".
After you attached the export item you will see the next screen:
The table below will explain what the different fields mean, so you can create a good export definition.
|Selected output format||
You can save the data directly from you reports, this will be the exact same data as when you download the reports from the BI webinterface.
|Direct output location||Here you specify the path where your file is stored.|
|Postprocess data using extension||When you want more controle over the data you can use the extension. Extentions will be supplied From ValueBlue. It is also possible to make them yourself.|
|Post process data||If you choose "Postprocess data using extension" you can select one of the known extensions in the dropdown.|
|Selected Extension parameters||Depending on the chosen extensions, the possible parameters of the chosen extension will appear here.|
|Empty before update||Here you can select if the database has to be emptied first before the synchronization starts.|
|Should this report refresh in the background||If you want you export to be refreshed over time, you have to check the box.|
|Update interval||Here you can select the synchronization interval in minutes.|
|Start on||You have to fill in the date from when you want the synchronization to start.|
To save the created export definition, choose "Save" in the "File" menu.
If you do not want to wait for the download interval or if you want to force a download, select the synchronization icon (top right with the export data).
Below you can see an overview of the differences between the BlueDolphin DataCollection versions
BlueDolphin DataCollection - 20180430
|Support for TLS1.1 & TLS 1.2|
|BlueDolphin DataCollection||Initial version, support for TLS 1.0|