Solved

How to setup BIRT data Source to point to SaaS Environment

  • 19 July 2022
  • 3 replies
  • 147 views
S
Rank
Userlevel 1
Badge +5

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?

icon

Best answer by simardl 19 July 2022, 18:58

View original

3 replies

S
Rank
Userlevel 1
Badge +5

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

K
Rank
Userlevel 3
Badge +8

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? 

S
Rank
Userlevel 1
Badge +5

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