Skip to main content
is a free, online data visualization and business intelligence tool for connection to various data sources and creation of interactive dashboards and reports. This connector enables clients to fetch data from an System for visualization in Looker Studio using the Google Apps Script platform.

​
Prerequisites

To use Looker Studio with the Ocient System, you must have this software:
  • Ocient System — Use the latest version.
  • A Google account with login credentials.

​
Connect to Ocient

Follow these steps to connect Looker Studio to your Ocient System.
1
Open Looker Studio and start a data source.
  • Go to https://lookerstudio.google.com/ and sign in.
  • On the home page, select:
    • Create > Data source, or
    • From an open report, Resource > Manage added data sources > Add a data source.
2
Select the Ocient Community Connector.
  • In the connector gallery, go to the Partner Connectors section.
  • Find and select the Ocient DB connector.
Looker Studio opens the Ocient Connector configuration page in the same tab.
3
Complete the configuration page by entering text in the fields. On the configuration page, select the Allow to be modified checkbox next to each field to modify it.This table contains descriptions for each field.
FieldDescription
HostnameHostname or IP address of the Ocient SQL Node.
DatabaseDatabase name in the Ocient System.
UserOcient username.
PasswordPassword for the Ocient username.
TableOcient table name (schema.table).
Row LimitLIMIT value to add to queries.
Date Range Column NameColumn name for the DATE or TIMESTAMP column in the WHERE clause.
Sort ColumnColumn name for the ORDER BY clause.
Sort OrderSort order with the option of ASCENDING or DESCENDING.
Unnest OptionSpecifies if array columns are unnested.
Custom QueryA query that overrides the query generated by the connector. The Looker data source panel shows only the columns included in this query.

In this mode, Looker Studio infers column data types from the sample output, and not a DESCRIBE TABLE SQL statement.
  • Select Connect.
  • Select Allow when Looker Studio prompts you with “Allow parameter sharing?.
You can now use Looker Studio to create reports for your Ocient System.
Looker Studio uses autocomplete in its filter tool, which can impact date or time filtering for records older than 28 days.To fix this issue, navigate to the Looker filter control and set Show suggested values to off.

​
Ocient Data Types in Looker Studio

The connector represents Ocient data types using the closest approximation supported by Looker Studio. The inference of data types happens in Looker Studio in these ways:
  • In normal mode, the connector generates data types from the table schema produced by a DESCRIBE TABLE SQL statement.
  • In custom query mode, Looker Studio infers data types from sample output.
This table shows how Ocient data types correspond to Looker Studio data types.
Ocient Data TypeLooker Studio Data TypeLimitations
BOOLEANBOOLEANNone
TINYINT,
SMALLINT,
INT,
BIGINT,
DOUBLE,
FLOAT,
DECIMAL		NUMBERNone
CHAR
VARCHAR
BINARY
HASH
IPV4
IP
UUID
VARBINARY
TIME		TEXTNone
POINT
LINESTRING
POLYGON		TEXTLooker Studio Community Connectors can use latitude or longitude coordinates, but they do not support native WKT geospatial types.
DATEYEAR_MONTH_DAYNone
TIMESTAMPYEAR_MONTH_DAY_SECONDNone
CHAR[],
VARCHAR[],
BINARY[],
HASH[],
IPV4[],
IP[],
UUID[],
VARBINARY[],
TUPLE[]		TEXTLooker Studio does not support arrays or tuples as a native data type. The connector represents container data types as textual strings.

For arrays, use the Unnest Option configuration field to flatten array columns for analytics.

For tuples, use the Custom Query field to extract the tuple elements. Setting the Unnest Option field does not work for flattening tuples.
Connect to Ocient Ocient Integrations
Last modified on May 27, 2026