Encrypting network trafficLooker strongly recommends encrypting network traffic between the Looker application and your database. Consider one of the options described on the Enabling secure database access documentation page. If you're interested in using SSL encryption, see the Oracle documentation. Creating a Looker userFirst, create a designated Looker user:
Next, give the new Looker user the ability to create sessions:
Finally, give the Looker user the appropriate
Ensuring Looker can see all tablesLooker may not be able to identify tables (especially empty tables) without first collecting statistics in Oracle. If tables you need do not appear in generated LookML or SQL Runner, try executing:
For alternative methods, consult your Oracle documentation. Setting up main database objectsYour Oracle DBA must set up the following objects and permissions on Oracle. The following commands create Run the following commands as the root user to complete this setup. These examples assume that the Looker user's name is
Setting up symmetric aggregatesYour Oracle DBA must set up the
Setting up persistent derived tablesTo enable persistent derived tables, give the Looker user the
Setting up query killingFollow these instructions to configure query killing for either a traditional Oracle deployment or an Amazon RDS deployment. Traditional Oracle deploymentsTo set up query killing in traditional Oracle deployments, the Oracle DBA must create the
The DBA will also need to run these related commands:
Amazon RDS deploymentsIn Amazon RDS Oracle deployments, the
To give the Looker database user query killing abilities, run:
Setting up the Looker connectionIn the Admin section of Looker, select Connections, and then select New Connection. The majority of these settings are common to most database dialects, and are described on the Connecting Looker to your database documentation page. The following settings are specific to Oracle or to the example Connections Settings page shown above:
Feature supportFor Looker to support some features, your database dialect must also support them. In the latest release of Looker, Oracle supports the following Looker features: Next stepsAfter you have completed the database configuration, connect to the database from Looker. |