on 05-01-2020 3:20 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
<ClassPath>
<Path>your jar or class files directory</Path>
</ClassPath>
–>
<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>
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.