Connecting to Teradata

👤 This documentation is intended for Site Administrators and/or Database Administrators.

Granting Permissions to Tables

Depending on the set up, the user may have opted to create a new user to connect exclusively to Sisense as a security measure. Even if this special user wasn't created, the connected user must have been granted SELECT permissions on the database and tables in order to access certain tables in Sisense. The commands below can be used for Teradata, and the examples below assume that the Sisense user has been named 'sisense'.

<body>
<blockquote>
<br>GRANT SELECT
<br>ON my_database
<br>TO sisense
</blockquote>‍
<blockquote>
<br>GRANT SELECT
<br>ON my_database.my_table
<br>TO sisense
</blockquote>
</body>

Private Network Access for Teradata

Private network access for Teradata requires a dedicated proxy server for SSH port forwarding or VPN. Teradata customers can opt to have Sisense deploy a server on their behalf as a managed service for a fee, or they may elect to configure and manage the service on their own without Sisense support.

Note: Site administrators can contact their Account Manager for additional information on the managed services.