When you want to import data once or not on a structural basis you can use the StandAlone Datacollection tool. This article contains a .zip file with the required software and a Template.json File.
When you extract the zip file, it contains a "DataCollection StandAlone.msi" file. Please install it on a computer which has access to the internet. Place the Template.json file in the installation folder.
After you installed the StandAlone DataCollector, open the file "DataCollection.Agent.Host.StandAloneImport.exe.config" which is in the installation folder (%PROGRAMFILESFOLDER%\ValueBlue BV\StandAloneImport). You need to configure the following settings to make the program work. The required values van be found in the General part of the Admin module.
|DataCollection.Tenant.APIKey||The value can be found in, Admin, General, Datacollection API key.|
|DataCollection.Tenant||The value can be found in, Admin, General, Database.|
When there is a Proxy server required to connect to the internet, there are configuration settings available for it.
|PresentationServiceUseProxy||true / false||Is a proxy server required|
|PresentationServiceProxyAddress||Proxy server address|
|PresentationServiceProxy UseCustomCredentials||true / false||Are there other credentials required to connect to the proxy.|
|PresentationServiceProxyUsername||Username to use to authenticate to the proxy server. Please user the format: %domain%\%username%|
|PresentationServiceProxyPassword||Password to use to authenticate to the proxy server|
When all settings are correct, start the StandAlone application, the screen below will be visible.
When not configured you can alter the Tenant & API Key before connecting to your BlueDolphin environment.
After you make sure the Tenant & API Key are correct, press "Connect", a connection to the specified BlueDolphin environment is made. When a connection is successful you can select a "Template". A Template prefills the "Data Provider", "Connection String" en "Select Statement" textboxes. You then only have to complete the information. See the figure below.
The table below explains the fields present in the DataCollector StandAlone.
|BlueDolphin Target Collection||
Here you specify the name of the collection. All data from the configured source will be loaded into this collection.
|Data Provider||Here are all possible data provider installed on the machine selectable. The active data provider is selected.|
|Connection String||Here is the connection string used by the Data Provider to open/connect to the datasource|
|Select Statement||Here is the select statement used by the data provider to extract the data from the datasouce (using the connection string specified)|
|Preview||By pressing the "Preview" button, you get a glimp of the result from the connection string and the select statement.|
Here you need to specify one or multiple fields to uniquely identify a row in the datasource. There must be a Primary Key present if you want the update functionality to work.
When you need mulitple field, you can seperate the fields using the ";" character
When you finished replacing the connection string and select statement, you can "Preview" to see if the data looks like you expected. When the data is ok, click on "Start Import" to send the data to your BlueDolphin environment.
Store and Load the configuration.
When you expect to import the exact same data again, you can store the information. You can do so by choosing for "File", "Save". The configuration is stored in a .xml file.
By choosing "File", "Load" you are able to load a stored .xml configuration file.
You can also use the .xml configuration file with the StandAlone command line.