Create a Connection to a Data Source

You can create a connection to enable you to analyze data in that data source.

  1. On your home page, click Create, and then click Connection.
  2. In the Select Connection Type dialog box, click the icon for the connection type that you want. For example, Oracle AI Database.
  3. Enter the required connection information such as host, port, username, password, and service name.
  4. Optional: Select an Authentication option for your connection..
    • Always use these credentials - Oracle Analytics always uses the login name and password you provide for the connection. Users aren’t prompted to log in.
    • Require users to enter their own credentials - Oracle Analytics prompts users to enter their own user name and password for the data source. Users can only access the data for which they have the permissions, privileges, and role assignments.
    • (Displayed if Oracle Analytics supports impersonation for this database type) Use the active user’s credentials - Oracle Analytics doesn't prompt users to sign in to access the data. The same credentials they used to sign in to Oracle Analytics are also used to access this data source.
  5. Click Save.
    You can now begin creating workbooks or datasets using this connection. For example, from the Home page, click Create, then click Dataset, then select the connection that you just created.