The ElastiCube Manager enables easy and quick access to databases, tables and views contained within Oracle databases. The steps below describe how to connect to this type of data source.

  1. Click Add data in the top menu of the ElastiCube Manager.
  2. Under the Database servers category, select Oracle Database.
    Add Oracle
  1. You are prompted to enter the following information:
  • Database server location: Enter the computer/server IP address with the database. To connect to a database running on your own computer, type in localhost.
  • Login details: Either use your Windows login details if they are configured with the database, or alternatively enter the username and password to connect to the database.
  • Use Direct Connection: You can also use a direct connection to connect. You will need to enter the Service ID and Port number to connect.
    • As long as you choose to work in direct mode to Oracle (this can be defined in the Oracle provider wizard), no client software needs to be installed. If you want to work with an already installed Oracle client, you can use the indirect mode, which assumes you have the Oracle client already installed.
    • Service ID can be found in the TNSNAmes.ora file. You can find a full description in the following topic: Service ID
    • Note that in the file for each tnsname, you can find the service ID and service name.
  1. Click Connect to Server.
  2. A list of available databases will appear in the list box below.
    oracle
  3. Select the relevant database you want to work with and click OK.

All tables and views associated with the database will appear in a new window.
To view a preview of data contained in a particular table, highlight the table or view in the list and in click the preview pane below. To preview the table, select the Preview checkbox.

oracle2

  1. Select the check box next to each table or view you want to use.
  2. If you want to customize the data before importing it into the ElastiCube, you can run a custom SQL query to manipulate the data. This can be useful, for example, when you want to import only a portion of the data, rather than all of the data. Click here to learn more.
  3. Once all relevant tables are selected, click Add.