Tag Archives: online courses

How to Connect Oracle BI Server with Tableau

How-to-Connect-Oracle-BI-Server-with-Tableau

Here, we will discuss about how to incorporate Oracle BI server and make use of the existing Subject Areas built on RPD in Tableau desktop workbook as Data Source.

NOTE: This is applicable for 8.2, 8.3, 9.0 and later versions.

Firstly, to launch an ODBC connection with the Oracle BI Server to access RPD Online, you have to install a copy of Oracle Business Intelligence Developer Client Tools (available from the Oracle website). Following, you can use the same DSN to connect to Tableau through ODBC connections.

2

As soon as you are done with installing the client, carry out the following steps to create a database source name (DSN):

  1. Follow the steps mentioned below to add a new system DSN for Oracle BI Server ODBC in the ODBC Administrator tool..
  • Go to the System DSN tab and click Add
  • Choose the Oracle BI Server DSN, among other available drivers

    1

    1. Give correct connection details and connect to BI Server

      2

      3. Save the System DSN
      In total, there are 3 levels in RPD:

      • Physical Layer (right pane) – This is the layer where a connection is established between each data source and the raw tables are disclosed. Joins across tables are performed here.
      • Business Layer (middle pane) – This is where logical relations, data modelling and hierarchy development are implemented.
      • Presentation Layer (left pane) – This is the layer exposed to the business through “subject areas”. The subject areas are clearly modelled to display data in the most easy-to-understand format.

      Under Tableau, tables in the presentation layer are adjoined as data sources, only.

      3

      Locate the Key Fields in Dimensions and Fact Table in Physical Layer of RPD and disclose the same to respective Presentation Tables in Presentation Layer of Sample Sales Lite Subject Area.

      4
      Create a “.tdc” file

      Create a Tableau data source customization (.tdc) file to connect Tableau Desktop to an Oracle BI server.

      1. Open a text editor; copy and paste the below code onto it:

      <connection-customization class=’genericodbc’ enabled=’true’ version=’9.3′><vendor name=’Oracle Business Intelligence’ />
      <driver name=’Oracle BI Server 1′ />
      <customizations>
      <customization name=’CAP_SET_ISOLATION_LEVEL_VIA_ODBC_API’ value=’no’ />
      <customization name=’CAP_SUPPRESS_DISCOVERY_QUERIES’ value=’no’ />
      <customization name=’SQL_CATALOG_USAGE’ value=’0′ />
      <customization name=’SQL_SCHEMA_USAGE’ value=’0′ />
      <customization name=’CAP_FAST_METADATA’ value=’yes’ />
      </customizations>
      </connection-customization>

      Nota bene: Version is crucial; adjust the version with that of your Tableau desktop version. In my case, it is 9.3.

      read full story

      Recently, credit risk analysis course in Noida is attracting a lot of attention. If you are looking for an exhaustive credit risk analysis course in Delhi, log into DexLab Analytics. You will surely get what you need!

      4

The Dilemma of Data Science: SAS or R or Python

The Dilemma of Data Science: SAS or R or Python

For a lot of quantitative corporate personnel, the raging debate between the tools of choice for analytics has been known to cause some rival enthusiasm instead of the age-old political debates on Thanksgiving!

The SAS vs. R debate was already hotly underway for the past couple of years, but recently many analytics professionals and aspiring analysts have requested us to include a comparison of Python in our debates. So, we decided to keep things light and simple and only asked a single question – “which analytics tool do your prefer to use: SAS, R Programming or Python?”

Read Also: Elementary Character Functions in SAS

Gradually our survey results have been showing a growing demand for open source tools over the past few years. In fact so much so, that this year almost 61.3% of respondents in a survey conducted by KDnuggets chose R and Python over 38.6 percent of people still opting for SAS. As it is SAS is a great tool for large companies to conduct their data analytics.

Read Also: 13 Advantages of R over Excel in Data Analytics

Are you keen on learning more about these numbers? So were we, so tallied a few survey results and opinions of analytics professionals to determine which is the better data analytics tool to learn first. And here is what we found…

read full story

%d bloggers like this: