{"id":751,"date":"2021-04-28T13:41:39","date_gmt":"2021-04-28T11:41:39","guid":{"rendered":"https:\/\/portal.diagnosticsincontrol.com\/?page_id=751"},"modified":"2021-05-26T17:08:13","modified_gmt":"2021-05-26T15:08:13","slug":"odbc-for-access-data-in-ms-power-bi","status":"publish","type":"page","link":"https:\/\/portal.diagnosticsincontrol.com\/index.php\/odbc-for-access-data-in-ms-power-bi\/","title":{"rendered":"Leverage MS Power BI Insights from GE Smallworld"},"content":{"rendered":"\n

Does your company use MS Power BI to gain insights in Business processes? Diagnostics can now help you leverage data from GE Smallworld. You can grasp the data from Diagnostics and make your KPI for the projects visible. Are you Quality requirements meeting the objectives? Are you improving your business?<\/p>\n\n\n\n

Diagnostics leverages the underlying technical solutions of Splunk. Splunk provides an ODBC connector and with this connector you can open up your data. With this simple install procedure, you can leverage the Diagnostics data in Microsoft Power BI.<\/p>\n\n\n\n

<\/p>\n\n\n\n

Install the driver for MS Power BI<\/h3>\n\n\n\n

Have your MS Power BI environment running. For example, the easiest installation: Power BI Desktop. You can also have the more advanced Power BI server but in that case, contact the Power BI server specialist for details.<\/p>\n\n\n\n

Let’s assume you have the standard Power BI Desktop installation running for Diagnostics on GE Smallworld.<\/p>\n\n\n\n

Now install the ODBC driver from Splunk on the machine running MS Power BI: https:\/\/splunkbase.splunk.com\/app\/1606\/<\/a>  <\/p>\n\n\n\n

Select the right version first (MS Windows or MacOS)<\/p>\n\n\n\n

Only install this driver: install the ODBC driver.<\/p>\n\n\n\n

Be sure to log in to your Diagnostics account. You need to create \u201csaved queries\u201d to access with MS Power BI.<\/p>\n\n\n\n

Configure<\/h3>\n\n\n\n

Start MS Power BI Desktop.<\/p>\n\n\n\n

Open a new data source by pressing \u201cGet data\u201d:<\/p>\n\n\n\n

\"MS
MS Power BI Get Data<\/figcaption><\/figure>\n\n\n\n

You will be shown all possible sources, and the ODBC driver is there too. Select it and select the “Splunk ODBC Data source name (DSN)”.<\/p>\n\n\n\n

You now have the possibility to access all saved queries and reports from Diagnostics on GE Smallworld.<\/p>\n\n\n\n

Example<\/h3>\n\n\n\n

I created an example for you:<\/p>\n\n\n\n

First, I created a test query \u201cGert Test Report 3\u201d<\/p>\n\n\n\n

Then I select it for import data in Power BI and simply loaded it.<\/p>\n\n\n\n

\"Get
Get Data interface retrieving data from GE Smallworld in MS Power BI<\/figcaption><\/figure>\n\n\n\n

Now you can create your dashboard.<\/p>\n\n\n\n

\"Result
Result of showing a Saved Query in MS Power BI <\/figcaption><\/figure>\n\n\n\n

In the example, I added Day in the x-axis and number of used license in the y-axis.<\/p>\n\n\n\n

And you have a simple dashboard representing the total number of used licenses in Smallworld. Now you can publish your dashboard to your Power BI gateway, MS SharePoint or MS Teams or where in your Microsoft ecosystem you want to present it.<\/p>\n\n\n\n

You can easily create your own Saved Query or ask Realworld Software Products BV to help you setting up the right queries that feed your data need.<\/p>\n\n\n\n

Reference and trademarks<\/h3>\n\n\n\n
\n

Microsoft and Power BI: https:\/\/powerbi.microsoft.com\/en-us\/<\/a><\/p>\n\n\n\n

\n

Diagnostics: www.diagnosticsincontrol.com<\/a><\/p>\n<\/div><\/div>\n\n\n\n

Smallworld: https:\/\/www.ge.com\/digital\/applications\/smallworld-gis-geospatial-asset-management<\/a><\/p>\n\n\n\n

Splunk\u00ae : https:\/\/www.splunk.com\/<\/a><\/p>\n\n\n\n

Splunk ODBC 1: https:\/\/www.splunk.com\/en_us\/solutions\/solution-areas\/business-analytics\/odbc-driver.html<\/a><\/p>\n\n\n\n

Splunk ODBC 2: https:\/\/docs.splunk.com\/Documentation\/ODBC\/3.1.0\/UseODBC\/AboutSplunkODBCDriver<\/a><\/p>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

Does your company use MS Power BI to gain insights in Business processes? Diagnostics can now help you leverage data from GE Smallworld. You can grasp the data from Diagnostics and make your KPI for the projects visible. Are you Quality requirements meeting the objectives? Are you improving your business? Diagnostics leverages the underlying technical … <\/p>\n

Continue reading “Leverage MS Power BI Insights from GE Smallworld”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-751","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/portal.diagnosticsincontrol.com\/index.php\/wp-json\/wp\/v2\/pages\/751"}],"collection":[{"href":"https:\/\/portal.diagnosticsincontrol.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/portal.diagnosticsincontrol.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/portal.diagnosticsincontrol.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/portal.diagnosticsincontrol.com\/index.php\/wp-json\/wp\/v2\/comments?post=751"}],"version-history":[{"count":12,"href":"https:\/\/portal.diagnosticsincontrol.com\/index.php\/wp-json\/wp\/v2\/pages\/751\/revisions"}],"predecessor-version":[{"id":787,"href":"https:\/\/portal.diagnosticsincontrol.com\/index.php\/wp-json\/wp\/v2\/pages\/751\/revisions\/787"}],"wp:attachment":[{"href":"https:\/\/portal.diagnosticsincontrol.com\/index.php\/wp-json\/wp\/v2\/media?parent=751"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}