This section describes how to create Google Sheets DSNs for use in Oracle Business Intelligence Enterprise Edition (OBIEE) installations on Linux.

Configure a DSN

Follow the procedure in Using the DataDirect Driver Manager to set the driver encoding, register the driver, and create a DSN. In OBIEE 12c, you can find the odbc.ini and odbcinst.ini configuration files in BI_DOMAIN/config/fmwconfig/bienv/core.

Test the Connection

To test the newly configured DSN 'CData GoogleSheets Source', you can use the nqcmd OBIEE utility command.