Learn more
 

Ready to get started?

Download a free trial of the SAP BusinessObjects BI Driver to get started:

 Download Now

Learn more:

SAP BusinessObjects BI Icon SAP BusinessObjects BI JDBC Driver

Rapidly create and deploy powerful Java applications that integrate with SAP BusinessObjects BI.

In this article

Related articles

Connect to SAP BusinessObjects BI Data in JRuby


Create a simple JRuby app with access to live SAP BusinessObjects BI data.

JRuby is a high-performance, stable, fully threaded Java implementation of the Ruby programming language. The CData JDBC Driver for SAP BusinessObjects BI makes it easy to integrate connectivity to live SAP BusinessObjects BI data in JRuby. This article shows how to create a simple JRuby app that connects to SAP BusinessObjects BI data, executes a query, and displays the results.

Configure a JDBC Connection to SAP BusinessObjects BI Data

Before creating the app, note the installation location for the JAR file for the JDBC Driver (typically C:\Program Files\CData\CData JDBC Driver for SAP BusinessObjects BI\lib).

JRuby natively supports JDBC, so you can easily connect to SAP BusinessObjects BI and execute SQL queries. Initialize the JDBC connection with the getConnection function of the java.sql.DriverManager class.

To connect to your SAP Business Objects BI instance, you must set the following connection properties:

  • Url: set this to the rest API URL. After logging into the Central Management Console, choose 'Applications' from the combo box. Double-click on 'RESTful Web Service' and you'll see the access URL. By default it is, http://{Server-Name}:6405/biprws.
  • User: set this to the username of your instance.
  • Password: set this to the password of your instance.

Built-in Connection String Designer

For assistance in constructing the JDBC URL, use the connection string designer built into the SAP BusinessObjects BI JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.

java -jar cdata.jdbc.sapbusinessobjectsbi.jar

Fill in the connection properties and copy the connection string to the clipboard.

Below is a typical JDBC connection string for SAP BusinessObjects BI:

jdbc:sapbusinessobjectsbi:User=username;Password=password;Url=http://myinstance:6405/biprws

Create a JRuby App with Connectivity to SAP BusinessObjects BI Data

Create a new Ruby file (for example: SAPBusinessObjectsBISelect.rb) and open it in a text editor. Copy the following code into your file:

require 'java' require 'rubygems' require 'C:/Program Files/CData/CData JDBC Driver for SAP BusinessObjects BI 2018/lib/cdata.jdbc.sapbusinessobjectsbi.jar' url = "jdbc:sapbusinessobjectsbi:User=username;Password=password;Url=http://myinstance:6405/biprws" conn = java.sql.DriverManager.getConnection(url) stmt = conn.createStatement rs = stmt.executeQuery("SELECT StoreName, TotalRevenue FROM MyCustomReport") while (rs.next) do puts rs.getString(1) + ' ' + rs.getString(2) end

With the file completed, you are ready to display your SAP BusinessObjects BI data with JRuby. To do so, simply run your file from the command line:

jruby -S SAPBusinessObjectsBISelect.rb

Writing SQL-92 queries to SAP BusinessObjects BI allows you to quickly and easily incorporate SAP BusinessObjects BI data into your own JRuby applications. Download a free trial today!