Questions regarding reporting in IFS assyst.
- 3 Topics
- 1 Reply
Does anyone currently utilize PowerBI for their reporting? Would the assyst community find it beneficial to potentially share some of the different templates you've created or structure you’ve put together to present useful and efficient reports?Thought it could be beneficial to center some of that in a community conversation thread as opposed to having to schedule calls with other IFS assyst customers through our account managers etc! Full disclosure we are in the exploratory stages of PowerBI as we transition from on-prem to SaaS with our assyst instance. Very interested in seeing what people have done and built, and of course if anyone is willing to collaborate and share all the better!
I am trying to change the data source of a BIRT report (e.g. rptdesign file used by assyst Report Wizard) from our on premise database to the cloud Saas Database, I was using Database URL “jdbc:sqlserver://W-99999-D5E:1523;databaseName=PDRPSQGCG;”and the connection was working fine.But now I was told to use “jdbc:sqlserver://cac-99301-axios.secondary.database.windows.net:1433;database=99301;” as an example but it fails the connection. I tried various combinations but still no success.IFS Support was not able to help other than we were able to test the connection tot he database using SSMS so all indication points to the BIST data source to be incorrectly specified.Does anyone have the proper info to setup the the connection?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.