cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Server 2019 Support- Reporting Data Source- XI 4.2 SP8

We would like to know if SQL Server 2019 can be used as a Reporting Data Source in Universes, Crystal Reports and Webi Reports. The PAM guide Page 24 on Data Access does say anything on SQL Server 2019 Support we only see support for SQL 2017 for the Data Source. Please confirm the support for SQL Server 2019 using BOE XI 4.2 SP8. We would also like to know the release data for XI 4.3.

denis_konovalov
Active Contributor
0 Kudos

I have fixed your tag to the one that deals with data connectivity and universes.

Accepted Solutions (0)

Answers (2)

Answers (2)

Sriram2009
Active Contributor
0 Kudos

Hi Julliet.

Refer the blog it may help you and answered your question.

https://blogs.sap.com/2020/02/24/sap-businessobjects-bi-4.2-sp08-sap-bi-4.2-sp8-released/

Regards

SS

denis_konovalov
Active Contributor
0 Kudos

Support for MS SQL 2019 as data source is planned to be added in 4.2 Sp9 (subject to change etc)
You can use generic odbc/jdbc connectivity for now to connect to it.

0 Kudos

So if we use IDT what is the driver type we should be using for Universe Connection Creation (JDBC 8.2) and what was the configuration that you used in the sqlsrv.sbo file to indicate that’s its SQL 2019. Example

<DataBase Active=”Yes” Name=”MS SQL Server 2017″>
<JDBCDriver>
<!– Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.microsoft.sqlserver.jdbc.SQLServerDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:sqlserver://$DATASOURCE$;DatabaseName=$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Extensions”>sqlsrv2017,sqlsrv,jdbc</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures,Cancel</Parameter>
</DataBase>