Access to Solibri Data to link to other applications (power BI, SQL databases)

petrinnn

Excelent topic @scorney … waiting for this also.

tonigyllenberg

Currently we have plans to develop exactly this feature! We are working to create an ITO API to initially fetch ITO data from Solibri. We are in the planning phase now, and hope to have a beta version out sometime this quarter.

Kind regards,

Toni on behalf of the Solibri team

scorney

@tonigyllenberg Great! Would be happy to test this out, please let me know when avaialble for testing.

scorney

@tonigyllenberg are there plans for this to work in combination with the autorun?

otsob

Currently a large part of the data that is shown in ITOs is accessible through the Rule API interfaces (e.g., relations, classifications, quantities).
Can you describe in more detail how you would want to access the model data within Solibri?

tonigyllenberg

Hello All!

As an update on this request, although we had announced about plans to implement a specific ITO API last year, we instead opted for more general additions to the API.

Beginning with 9.12.0, the API allows access to any piece of information of components, and because of this, we are confident that such a PowerBI connection can be implemented in different ways. This also implies that the results of automatically updated executed ITOs could be accessed and transferred.

Specifically regarding ITO results, currently (from version 9.10.8) using the API, it is possible to:

Read ITO results
Create custom information columns
Read custom information from custom information columns

Coming with 9.12.0 release:

Execute ITO calculation

If you have a more specific idea of what type of information you would like to link in a PowerBI project, please let us know, and we can provide more information on how this could be supported.

Kind regards,

Toni on behalf of the Solibri team

scorney

Great news. What is the ETA on the 9.12.0 version?

scorney

We use Power BI for cost tracking so we would like to extract be elements types (either IFC entity or classification), by floor level, volume, weight, model name, revision, date IFC exported etc…and some other custom property sets.

tonigyllenberg

@scorney said in Access to Solibri Data to link to other applications (power BI, SQL databases):

Great news. What is the ETA on the 9.12.0 version?

Hello @scorney,

We are in the final stages of testing, QA and packaging. We are aiming to have the product ready to be released this week.

Kind regards,
Toni on behalf of the Solibri team

scorney

Hi Tony,

With the 9.12.0 version released what is the best workflow to link up the data to power BI?

Keen to understand how this would work.

Thanks,
Stephen

lasse.lindqvist

Hi.
It is definitely possible to have a Solibri-to-PowerBI flow and not that hard really. One of the examples show how to export checking results to an SQLite database, which can be directly imported into Power BI. (For example https://community.powerbi.com/t5/Power-Query/connecting-a-SQLite-database/td-p/224205)

How to implement it with the API depends on what kind of an exact workflow you are looking for. One way to do it would be to create a custom view that automatically, or from a press of a button, exports the ITO or checking results to an SQLite database. But if you want to go all in and automate the whole flow, you can also call Power BI REST API from the custom view (https://docs.microsoft.com/en-us/rest/api/power-bi/) and skip the SQLite step completely. The results would appear in Power BI automatically after every checking or ITO calculation.

The Java API can be used to read the ITO rows (https://solibri.github.io/Developer-Platform/9.12.0/javadoc/com/solibri/smc/api/ito/InformationTakeoff.html#getRows()) and this has been possible from version 9.10.8.
Checking results (https://solibri.github.io/Developer-Platform/9.12.0/javadoc/com/solibri/smc/api/checking/Checking.html#getResults()) have been accessible from 9.10.6.

paultoner

Hi, was there ever a Solibri solution to this? I cant find any information on it.