This topic describes how to connect Tableau to a Teradata database or a Teradata Unity server and set up the data source.
Before you begin
Before you begin, gather this connection information:
Driver required
Here is the Teradata installation guide with screenshots. Teradata releases pre-installed image for Teradata Express for Vmware Workstation/Player. By installing this, you can access teradata from your local system using Teradata SQL Assistant, Teradata Administrator or any other utilities like BTEQ, FASTLOAD, MLOAD etc. 15.10 - Downloading and Installing Third-Party Software for Teradata SQL Assistant - Teradata Tools and Utilities Teradata Tools and Utilities for Apple OS X Installation Guide prodname Teradata Tools and Utilities vrmrelease 15.10 createddate August 2016 category Installation featnum B035-3129-125K.
![]()
This connector requires a driver to talk to the database. You might already have the required driver installed on your computer. If the driver is not installed on your computer, Tableau displays a message in the connection dialog box with a link to the Driver Download(Link opens in a new window) page where you can find driver links and installation instructions.
Make the connection and set up the data source
Sign in on a Mac
If you use Tableau Desktop on a Mac, when you enter the server name to connect, use a fully qualified domain name, such as mydb.test.ourdomain.lan, instead of a relative domain name, such as mydb or mydb.test.
Alternatively, you can add the domain to the list of Search Domains for the Mac computer so that when you connect, you need to provide only the server name. To update the list of Search Domains, go to System Preferences > Network > Advanced, and then open the DNS tab.
Use query bands to increase performance
When you connect to a Teradata database, you can optionally define query band statements that run during connection. These statements can increase performance, and they take advantage of the built-in security rules of the database.
Using query bands, you can pass parameters into the Teradata environment. Use these to set up a workbook to filter the data based on security rules that exist in the database. For example, you can pass in the Tableau Server user name for the current user so that when the view is loaded it only shows the data specific to that user. Query bands can also be used to improve performance. When connecting to Teradata, you can define a map between the name of the attributes passed into the query band and the corresponding values from Tableau.
To set up query banding:
An example query band statement is shown below. This example passes the user name for the current server user.
Tableau checks the statement for errors as you type. When it is valid a green check mark displays at the bottom of the text box.
Teradata Sql Assistant Tutorial![]() Use initial SQL commandsTeradata Sql Assistant 14.10 Download
When you connect to a Teradata database, you can optionally specify a SQL command that will be run once upon connection. See Run Initial SQL to learn more about adding these commands to your connection.
Teradata Sql Assistant 15.10 Download
Note: If Tableau detects that the Initial SQL payload cannot be delivered in one query, it attempts to split the query into separate statements, where each statement must end with a semicolon followed by a newline character, with no additional characters (such as an extra space) in between. This requirement is important because if a semicolon exists within the interior of a statement, for example within a string literal, it may not be safe to split the statement at that point. If the Initial SQL code that you specify in Tableau returns an error, and the same Initial SQL is deemed valid by the Teradata databases, it may be that Tableau has split the query incorrectly. Mac os x version 10 7 download. If this happens, try reformatting the SQL code in Tableau manually.
See alsoTeradata Sql Assistant Help
Teradata Sql Assistant 16 DownloadThanks for your feedback!There was an error submitting your feedback. Please try again.Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |