10/14/2019 10:20 AM | |
Joined: 5/31/2011 Last visit: 8/6/2024 Posts: 190 Rating: (31) |
Hey all, Is it possible that the runtime database name is fixed in WinCC Professional? Each time you compile the project, the runtime gets a different name with the date and time. For example the name is "CC_HMI_7HI6_19_10_14_09_57_05R' This is an issue if you want to make a DB connection with a third party software as Microsoft PowerBI (see post https://support.industry.siemens.com/tf/ww/en/posts/microsoft-powerbi-connection-to-wincc-oledb-provider/221775/?page=0&pageSize=10#post880183) So I'm wondering if it is possible that the runtime DB gets a fixed name. |
Last edited by: ThaKibosh at: 10/14/2019 10:37:40Last edited by: ThaKibosh at: 10/14/2019 10:43:03 |
|
10/24/2019 11:44 AM | |
Joined: 5/31/2011 Last visit: 8/6/2024 Posts: 190 Rating: (31) |
Thx for the replies, For the WinCC v7.+ project we are using connectivity pack. OPC is another licence if I'm correct. I'm going to try out what "Murof" wrote and see what it does. The third party software is "Microsoft Power-BI" and after testing it seems to be very difficult to make a "dynamic" connection to a database that is changing name. I was able to read out and filter to the runtime database, but when you restart PowerBI it tries to connect to the old db-name with the credentials. It's saving the last connections seperately. Yes, Microsoft made it to complex (again)... For who is interested the link to the Power-BI forum with my question: https://community.powerbi.com/t5/Power-Query/query-in-query-Dynamic-database-name/m-p/823958#M27703 |
Follow us on