We need to download the correct JDBC driver for the version of SAPJVM that our release of SAP BI 4.x is running on. Step 1 – Download MS SQLServer JDBC drivers from Microsoft sbo files’ approach but is a good example of this alternative, painful approach. Microsoft SQL Server Connection With JDBC On Linux Unix or AIX – uses the ‘editing.download-microsoft-jdbc-driver-for-sql-server-2017.
microsoft-jdbc-driver-for-sql-server-2017.In this example we’ll connect SAP BI 4.2 SP7 with MS SQLServer 2017. SQuirrel SQL – JDBC connectivity testing tool.Connecting to Sybase SQL Anywhere (tbc).Connecting to Azure Datawarehouse (tbc).sbo ExtensionsĬheck out the SQuirreL SQL section at the bottom of this blog post for a useful connectivity testing tool and examples of connection strings. 2521502 – How to configure JDBC connection using Extensions for IDT, UDT and Webi.2112338 – List of Bundled Tomcat and JVM versions shipped with each version.The DataAccess Guide for your specific release of SAP BI 4.x available from SAP Help Portal.We’ll be using the Extensions approach, which is pretty simple as the other is just the way of pain! Useful Using Extensions approach with sub-folders in the connection-server folders.sbo files in the connection-server folders
They both involve changes to the SAP BI 4.x connection-server files. Note that as far as SAP BI 4.x connectivity is concerned, and this is documented in the SAP BI 4.x DataAccess Guides, there are two main ways of configuring JDBC connectivity. As it is a WIP I hope to keep on updating it going forward.
This is my first blog post and there are a couple of supporting blog posts I need to put together to help with the basics on this one. The target audience are those among us who don’t necessarily do ‘techie work’ day2day but have some task put on them that they just need to get done. There are a number of useful blog posts covering this topic but hopefully I can add some useful information and troubleshooting. This blog post describes setting up JDBC connectivity to various databases, from SAP BI 4.x client and server machines on MS Windows and linux.
0 kommentar(er)
