(For more resources on Oracle 11g, see here.)
The Data Model Editor’s interface deals with all the components and functionalities needed for the data model to achieve the structure you need. However, the main component is the Data Set. In order to create a data model structure in BIP, you can choose from a variety of data set types, such as:
Taking advantage of this variety requires multiple Data Sources of different types to be defined in the BIP. In this article, we will see:
Let’s first see, how you can verify or configure your data sources. You must choose the Administration link found in the upper-right corner of any of the BIP interface pages, as shown in the following screenshot:
The connection to your database can be choosen from the following connection types:
To get to your data source, BIP offers two possibilities:
In the following sections, the Data Source types&mdashJDBC, JNDI, OLAP Connections, and File&mdashwill be explained in detail.
Let’s take the first example. To configure a Data Source to use JDBC, from the Administration page, choose JDBC Connection from the Data Sources types list, as shown in the following screenshot:
You can see the requested parameters for configuring a JDBC connection in the following screenshot:
The Use System User option allows you to use the operating system’s credentials as your credentials. For example, in this case, your MS SQL Database Server uses Windows authentication as the only authentication method.
When you have a system administrator in-charge of these configurations, all you have to do is to find which are the available Data Sources and eventually you can check if the connection works. Click on the Test Connection button at the bottom of the page to test the connection:
JNDI Connection pool is in fact another way to access your JDBC Data Sources. Using a connection pool increases efficiency by maintaining a cache of physical connections that can be reused, allowing multiple clients to share a small number of physical connections.
In order to configure a Data Source to use JNDI, from the Administration page, choose JNDI Connection from the Data Sources types list. The following screen will appear:
As you can see in the preceding screenshot, on the Add Data Source page you must enter the following parameters:
The users having roles included in Allowed Roles list only will be able to create reports using this Data Source.
Use the OLAP Connection to connect to OLAP databases. BI Publisher supports the following OLAP types:
In order to configure a connection to an OLAP database, from the Administration page, choose OLAP Connection from the Data Sources types list. The following screen will appear:
On the Add Data Source page, the following parameters must be entered:
Format: [server name]
Format: Data Source=[server];Provider=msolap;Initial Catalog=[catalog]
Format: Data Source=[server];Provider=msolap.3;Initial Catalog=[catalog]
Format: ASHOST=[server] SYSNR=[system number] CLIENT=[client] LANG=[language]
Another example of a data source type is File. In order to gain access to XML or Excel files, you need a File Data Source. In order to set up this kind of Data Source, only one step is required&mdashenter the path to the Directory in which your files reside. You can see in the following screenshot that demo files Data Source points to the default BIP files directory. The file needs to be accessible from the BI Server (not on your local machine):
I remember deciding to pursue my first IT certification, the CompTIA A+. I had signed…
Key takeaways The transformer architecture has proved to be revolutionary in outperforming the classical RNN…
Once we learn how to deploy an Ubuntu server, how to manage users, and how…
Key-takeaways: Clean code isn’t just a nice thing to have or a luxury in software projects; it's a necessity. If we…
While developing a web application, or setting dynamic pages and meta tags we need to deal with…
Software architecture is one of the most discussed topics in the software industry today, and…