Skip to main content

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?

Ok this was resolved by updating to the latest SQLServer Driver V10.2

We have been struggling to get BIRT to connect to our Hosted SaaS environment. We contacted the service desk yesterday afternoon and they confirmed it isn’t possible to connect to an IFS hosted SaaS database - are IFS hosting your SaaS environment or are you? 

IFS is hosting our SaaS environment.

They had to white list the IP of my computer for it to be able to establish a connection.

Reply


Terms & ConditionsCookie settings