Time series Data Providers¶
The Data Provider concept in MIKE OPERATIONS, allows MIKE OPERATIONS to connect to time series stored in other types of water data systems.
DIMS.CORE¶
For water environments, DIMS.CORE provides the perfect data repository for your management and real time operation data and turns data into invaluable information concerning the performance. DIMS.CORE can link to all data sources, share and provide data to users worldwide. DIMS.CORE has an impressive track record of combining multiple data sources into one platform and providing tailored reports on your water related business processes.
The DIMS.CORE data provider allows MIKE OPERATIONS to use time series stored in DIMS.CORE.
Connect to DIMS.CORE timeseries¶
In DIMS.CORE System Configuration¶
Check if you have a gateway configured.
If not, create a new gateway with the button.
Select database, write password and press OK.
The gateway is now visible.
In DIMS.CORE Designer¶
Right click on the root and select Database connection.
Copy the string in the Token window.
In MIKE Workbench¶
Right click on the root and select Edit Provider(s) Connections(s)...
Select DIMS.CORE and paste the token.
Right click on the root and Select Register DIMS time series.
Select the DIMS.CORE time series to connect to click Register.
Close
The DIMS.CORE time series are ready to be used.
MIKE Cloud¶
MIKE Cloud is an open platform, providing storage for time series, spatial data and blob data in the Cloud.
The MIKE Cloud Time Series Provider allow time series stored in MIKE Cloud to be used in MIKE OPERATIONS as if they were stored in the MIKE OPERATIONS database.
Benefits of MIKE Cloud includes:
- Scalable computing power
- Multi-user collaboration
- Custom software creation
- Partnerships and integration with 3rd party technology
- Access to open data
- Enabling digital twins and operational control
Read more about the DHI Cloud Platform here
Configure Provider in MIKE Workbench¶
Access to MIKE Cloud, requires either a DHI single sign-in user or an Open API key, created in the DHI Admin Center (see section about creating Open API keys). The API Key or user should be associated to one or more projects.
MIKE Cloud Provider connections has to be created in the Time Series Explorer, right clicking the root node of the explorer and selecting Edit Provider(s) Connection(s)....
The connection string contains the following information (separated by a semicolon ;).
- Environment (Prod, Dev, Test)
Default is Prod (production). If the environment is not specified, Prod is used. - API key
The API key (a GUID) generated in the DHI Azure Admin Center. The API key is not required when using DHI single sign-on.
By default, the connection string is empty. This means that the Production environment is used, and that DHI single sign-on is used.
DHI single sign-on requires a login and is not suitable when using e.g. the job service of MIKE OPERATIONS for running scheduled jobs. In this case using an API key is recommended.
Select OK when the connection string has been specified.
Tip
If the connection fails, you should clear the cache by deleting the file (for Prod):
%localappdata%\DHI.oidccache.bin
Register Time Series¶
When a MIKE Cloud provider has been configured, it is possible to register MIKE Cloud time series from the context menu of the Time Series Explorer root node.
Selecting Register MIKE Cloud time series will show all available MIKE Cloud time series of projects associated to the AppKey.
Check the time series to register and click the Register button to create time series links in the time series explorer.
Registered time series will be placed on the root node but can be moved into folders created in the Time Series explorer.
Time series data are kept in MIKE Cloud and are not stored in the MIKE OPERATIONS database. Only an entry for the time series with a link id are created in the time_series table of the database.
Get Access to MIKE Cloud¶
Access to MIKE Cloud using a MIKE Cloud Azure subscription is required in order to configure the MIKE Cloud Provider in MIKE OPERATIONS.
MIKE Cloud Subscription¶
The MIKE Cloud subscription can be bought by contacting the sales
department of DHI by sending a mail to mike@dhigroup.com
The MIKE Cloud Provider only requires time series storage and a single admin user able to create AppKeys for the MIKE Cloud Platform.
The DHI sales department can help in deciding the right subscription to use.
Admin Center¶
Admin Center is the app which the Admin users have access to. From here you can on-board additional users by invitation.
The first Admin Users is set up during the sign-up process and added by DHI. Additional users should be invited by the Admin User.
The Admin User can nominate other users become Admin Users and hereby enable them to enroll additional users.
Creating Open API key¶
For communicating via API instead of using the user interface an Open API key needs to be created.
To create the API key you will have to be an Admin User, as they are the only ones with access to Admin Center.
Create an API Account¶
Give the account a static name (cannot be changed) and a Display name - which is the name that will be displayed referring to the Key's under this account. Each account can hold several key's.
Press create, which will list the created account in the account list.
Find it a press edit to get a Key created.
Press the create new key button and a key will be generated - you can copy this to your clipboard by clicking the copy icon. The key is only visible while the side panel is open, next time you open it will be xx'ed out.
Add your API Account to a project¶
Go to Data Admin - and choose the project you want the API Account to be a member of.
Click edit project and search for the Account to add it in the members section - also remember to grant it sufficient rights to write to the project.
MIKE OPERATIONS Provider¶
The Time Series MO Provider allows connection to other MIKE OPERATIONS databases.
Configure Provider in MIKE Workbench¶
The connection string of the provider can be achieved by starting MIKE Workbench with the database connection that needs to be accessed.
Select Get MIKE OPERATIONS Provider Token from the context menu of the time series explorer root node.
Type in you password and click the Create Token button.
When the token has been generated, it can be copied to the clipboard with the Copy button and pasted into the provider connection string in MIKE Workbench from where to access to MIKE OPERATIONS database.
Folder Provider (dfs0)¶
The Folder Provider provides access to time series stored on disk as dfs0 files.
The connection string of the provider is the full path of the folder on disk containing dfs0 files.
The folder path specified will only show files in this folder and not in sub folders.
Note
Note that the Folder Provider is available from MIKE OPERATIONS 2025.0.
Configure Provider in MIKE Workbench¶
Time series Folder Provider connections has to be created in the Time Series Explorer.
Right click the root node of the explorer and selecting Edit Provider(s) Connection(s)....
The connection string should contain the full path to the folder containing .dfs0 files.
Select OK when the connection string has been specified.
Register Time Series¶
When a Time series Folder provider has been configured, it is possible to register .dfs0 time series from the context menu of the Time Series Explorer root node.
This will open a data view where the time series (dfs0 files) to register can be selected.
Target group specifies the time series group to place the time series to be registered. By default, time series will be displayed in the root folder.
Click Register when the time series to register has been selected.
The regisered time series will be places in target group specified in the registration data view.
