Error: "No ODBC system data source is defined for Oracle BI Server"

Error: 

"No ODBC system data source is defined for Oracle BI Server" When Launching The Oracle BI Administrator In Online Mode Using a Newly Created OBIEE 12c Domain.

I was attempting to launch the Oracle BI Administrator (BI Developer Client Tool) in online mode using a newly created OBIEE 12c domain, the following error occurs:

STEPS TO REPRODUCE

The following steps can be utilized to reproduce the error:

• Browse to $BIDomain\bitools\bin
• Launch admintool.cmd
• Select File > Open > Online (or select the blue folder icon)
• Note the error which occurs as mentioned above.

CAUSE

This issue is caused by a missing ODBC System DSN for the OBIEE domain installed on Windows.

When creating the domain for OBIEE 12c, if creating a new domain using the Primavera Analytics BAR file or creating the OBI domain using the "clean slate" deployment method, a System ODBC DSN is not created out of box.  When using the Administrator in online mode, this DSN is required and if not present will return the reported error.

SOLUTION

To resolve this issue, you must create a System DNS for the OBIEE domain using the following low level steps:

1. Browse to Control Panel > Administrative Tools
2. Click Data Sources (ODBC)
3. In the ODBC Data Sources Administrator Screen, click System DSN
4. Select Add...
5. On the Create New Data Source screen, select Oracle BI Server, then Finish
6. In the Oracle BI Server DSN Configuration:

• Enter any name in the name field
• Enter any description in the description field
• Enter the servername for BI Server in the server field.
• Select Next
• Enter a login ID/password with Administrator role (for example, weblogic user of the OBIEE 12c domain)
• In the Port field, enter the port number for the obis bi server process
• By default, 9514. 
• This can be found in Enterprise Manager:
• Click Target Navigation icon (ss1) > Business Intelligence > biinstance > Availability > Processes tab
• Select the Save login ID checkbox
• Select the Connect checkbox
• Select Next
• Select Finish

• Close the ODBC Data Source Administrator screen. 
• Relaunch the Oracle BI Administrator tool and the system DSN will now be available.

Reference: docs.oracle.com

Happy Blogging.!!

How to Install Data Visualisation Desktop(DVD) on Windows 10? DVD 12c

As we all know, installation of Oracle Analytics Desktop is a straightforward like in general software installation with Next > Next and Next.

Having said this, though we have installed Analytics Desktop in easy way, it doesn't include everything that it can offer, as Machine learning and advanced analytics are optional components that's why they aren't included in the Oracle Analytics Desktop installation. You must install machine learning to use Diagnostics Analytics (Explain), Machine Learning Studio, or advanced analytics.

Follow below steps to install Data Visualisation Machine Learning Framework on Windows.

• Go to the Windows Start menu, browse to Oracle, and click Install DVML
  
  
  

• The installer starts on completion of the download. Follow the displayed instructions to install machine learning to the selected install path.

• Click Finish to close the installer.
• When prompted, press any key to close the terminal window.
  
• If Oracle Analytics Desktop was running during the installation, then restart it.

I hope this helps, cheers.!!