User Guide
Table of Contents
This Document explains how to use the Dyno Card solution, specifically it explains generate data from the Simulator and how to verify the output of the project/solution.
- Go to Resource Group -> Click on dynocardVM.
-
Now It will direct to overview page of the dynocardVM.
-
Copy the public IP address.
- Open Remote Desktop Connection on your local computer and paste the copied dynocardVM Public IP address.
-
Use the below Credentials for login to the VM.
User_ID: adminuser
Password: Password@1234
-
Click Ok
- Now Click Yes button to continue.
- It should open the dynocardVM. Open a Windows Explorer window and check to make sure the downloaded software is present.
Note: Path to check the downloaded Softwares is “C:\” (Click on This PC and click C drive)
Note: Before Running the Modbus Simulator, you need to stop the Windows Firewall.
- Go to Control panel -> Network and Internet -> Network and Sharing Center window and then click on Windows Firewall which is located in the left bottom of the pane.
- Click Turn Windows Firewall on or off, which is located in the left side Menu bar.
- When you click Turn Windows Firewall on or off, you will be directed to below page.
- Now select Turn off windows firewall radio button for both public and private network settings then click ok.
- Now you can see, the Windows Firewalls of dynocardVM are stopped.
- Run the 2nd version of ModRSsim2 simulator by double clicking it.
- Click on Animation setting icon, which is in the right-side menu bar.
- Select the "Training PLC Simulation" option and browse the DynoCard.vbs script in downloaded section of the VM.
- Select Analog Inputs 300000.
- Now Close the Simulator window and then open the version 1 of the Simulator, which should be installed in the C:\Program Files (x86)\EmbeddedIntelligence\Mod_RSsim directory.
-
Click on the same Animation setting icon, which is located in right side menu bar to verify the DynoCard.vbs script is selected or not.
-
if it’s not selected, then Select the "Training PLC Simulation" option and browse the DynoCard.vbs script in downloaded section of the VM.
-
Now Select Analog Inputs 300000 then you can observe the received/sent data count which is highlighted in below screen. Data from dynoCardVM will be sent to iotedge device's modbus module.
Login to iotEdge VM:
- Go to -> Resource group -> Click on iotEdge VM
- After clicking on iotEdge VM, you will be directed to iotEdge overview page. Here Copy the iotEdge VM Public IP address.
- Now Open Putty and Paste the Public IP addres of iotEdge VM into the Host Name (or IP address) box and then click Open.
- Then click Yes to continue.
-
Enter the Login Credentials:
Username as: adminuser
Password as: Password@1234
- Once login is successful. Run the below command for root privilege.
sudo -i
- Run the below command to check whether the data is coming from Modbus simulator or not.
docker logs modbus
- Modbus container logs show the data that is coming from modbus simulator and minimize the screen.
-
- To verify whether all modules on the edge device are running or not, go to Resource group -> Click on iothub26hs3
- Navigate to IoT Edge blade under the Automatic Device Management section.
- Here we created and configured device from the IoT Edge VM. Click on iot-dynocard-demo-device_1 device to see the modules.
- We can see the created modules in device details
- Go to Resource group -> Click on db4cards SQL database and copy the server name.
- Download and Install the SQL Server Management Studio on your local machine. Open SQL Server Management studio and past the server URL.
Credentials:
Login_ID: adminuser
Password: Password@1234
Note: Before login to SQL database you need to add firewall settings.
- Go to Resource Group ->click on oilgasserver26hrs3.
- Click Show Firewall Settings from the Firewalls and virtual networks.
- Click + Add client IP to add the client IP address.
- As shown below added the client ip address form the Firewall and virtual networks and click Save.
-
Go back to SQL Server Management Studio and click on connect.
-
After connecting to the server, expand the tables and views inside the db4cards database as shown below.
- Check the data in each table by running the following SQL Commands.
select * From [ACTIVE].[CARD_DETAIL]
select * From [ACTIVE].[CARD_HEADER]
select * From [ACTIVE].[DYNO_CARD]
select * From [ACTIVE].[EVENT]
select * From [ACTIVE].[EVENT_DETAIL]
select * From [ACTIVE].[PUMP]
select * From [STAGE].[PUMP_DATA]
select * From [STAGE].[SURFACE_DATA]
- Select data from [ACTIVE].[DYNO_CARD_ANOMALY_VIEW]
To check the data in ACTIVE.DYNO_CARD_ANOMALY View follow the steps below.
Right click on [ACTIVE].[DYNO_CARD_ANOMALY_VIEW] --> script view as -->select to -->New Query Editor window.
-
Login to edge sql Container using SQL Server Management Studio.
-
Copy the Edge VM IP Address:[104.42.121.3] and give port 1401.
Credentials:
EX: 104.42.121.3,1401
User_ID: sa
Password: Strong!Passw0rd
- Check the data in tables.
select * From [ACTIVE].[CARD_DETAIL]
select * from [ACTIVE].[CARD_HEADER]
select * from [ACTIVE].[DYNO_CARD]
select * from [ACTIVE].[EVENT]
select * from [ACTIVE].[EVENT_DETAIL]
select * from [ACTIVE].[PUMP]
select * from [STAGE].[PUMP_DATA]
select * from [STAGE].[SURFACE_DATA]
- Select data from [ACTIVE].[DYNO_CARD_ANOMALY_VIEW]
Right click on [ACTIVE].[DYNO_CARD_ANOMALY_VIEW] --> script view as -->select to -->New Query Editor window.
Before configuring Power BI, you need to download and install the power BI Desktop application.
You can perform the below steps in Power BI Desktop:
Download Power Bi desktop from below link.
https://www.microsoft.com/en-us/download/details.aspx?id=45331
Download dynoCardVisuals.pbiviz file from the below link
https://github.com/BlueMetal/iot-edge-dynocard/tree/master/dynoCardVisuals/dist
- Open Power BI Desktop and select the ellipses from the bottom of the Visualizations pane.
- From the drop-down, select Import from file.
- Caution: Import Custom visual --> dialog box will appear. Click Import to confirm.
- From the Open file menu navigate to dynoCardVisuals.pbiviz file and then select Open. The icon for Dyno Card custom visual will be added to the bottom of Visualizations pane and it's now available for use.
- In the top left-hand side of Power BI Desktop, select 'Get Data' -> 'SQL Server database' and click on Connect.
- Fill in the database server information and click 'OK'.
To get the database information, go to Resource group.
Click on db4cards database
Copy the server name and database name
• Server: xxxx.database.windows.net
• Database: db4cards
• Database Connectivity Mode: Import
-
Select 'Database' on the left-hand side of the connection window, fill in the database connection information and click 'Connect'.
• Username: <> • Password: <>
- Select 'ACTIVE.DYNO_CARD_ANOMALY_VIEW' from the navigation list and Click load.
- Add the Dynocard Visualization to the report by clicking on the icon and then map the imported fields accordingly.
- Drag and drop all the fields respectively.
Now reports can be observed like below.
********************************* END OF DOCUMENT ***************************************