A Create ODBC Connection for Oracle Analytics Server Administration Tool
This appendix comprises the steps to create ODBC connection for Oracle Analytics Server Administration tool.
- Navigate to Control Panel > All Control Panel Items > Administrative Tools.
-
Double-click Data Sources (ODBC) (64-bit).
The ODBC Data Source Administrator (64-bit) dialog box appears.
-
From the System DSN tab, and click Add.
The Create New Data Source dialog box appears.
-
From the list of the available drivers, select Oracle BI Server, and click Finish.
The Oracle Oracle Analytics Server DSN Configuration dialog box appears.
-
Enter the following fields:
-
Name—AN_DSN (or any name)
-
Description
-
Server—Oracle Analytics Server Name (FQDN)
-
-
Click Next.
-
Login ID—AN_DSN (or any name)
-
Password
-
Port—The port must be same as mentioned in the Managed Server port list for Oracle Analytics Server.
To retrieve this port, go to Enterprise Manager > BI Instance > Availability tab.
-
- Click Next.
- Click Finish.