Install and configure Admin Tool with OBIEE 12C - IAAS Cloud

First of all you need to install the client required, the file:

Setup_BI_Client_12.2.1.0.0_Windows.X64

you can download it en the oracle web page, or e-delivery.

http://download.oracle.com/otn/nt/bi/1221/Setup_BI_Client_12.2.1.0.0_Windows.X64.zip

once you have installed, we proceed to configure it in order to allow connection,

we need first, configure tnsnames.ora.

1.- Navigate to C:\Oracle\Middleware\Oracle_Home\network\admin
(if the folder doesn't exist create it)

2.- Create file tnsnames.ora pointing out to the database you want to connect.

example:

# tnsnames.ora Network Configuration File mntopc_dataproduct12.1.0db_1networkadmintnsnames.ora
# Generated by Oracle configuration tools.

CLOUDCDB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = db_private)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = cloudcdb1)
    )
  )

CLOUDCDB1_PDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = db_private)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pdborcl)
    )
  )

3.- Configure DNS System Entries

The port 9514

4.- Select the tables as you desire and build your model