Accessing DataArtsFabric SQL Using Tableau
Tableau is a popular BI tool in the industry. For relational databases, you can use JDBC APIs to interact with a database through the JDBC driver.
Obtaining Tableau
You can obtain the latest Tableau version from the Tableau official website.
Interconnecting DataArtsFabric SQL with JDBC
- Obtain JDBC. For details, see Obtaining JDBC.
- Install JDBC as instructed. After the installation is complete, find the Drivers folder in the Tableau installation directory and copy the JDBC JAR file to the folder.
The following is an example of the directory on Windows. For details, see Tableau and JDBC.
C:\Program Files\Tableau\Drivers
- Open Tableau. Click Other Databases (JDBC).
If this option is not displayed, click More and then click Other Databases (JDBC).
- Enter the JDBC URL in URL and select PostgreSQL for Dialect.
JDBC URL template:
jdbc:fabricsql://<host>[:<port>]/<database>
Example:
jdbc:fabricsql://example.com:1234/database
Parameter
Description
host
DataArtsFabric SQL address
port
(Optional) Port number
database
(Required) Database name, which can be customized.
Additionally, you need to configure Properties file for authentication. Click Browse and select the compiled property file. The extension name of the property file is .properties. In this example, the property file is named serverless.properties. Then, click Sign in.
The following shows an example of the property file:
AccessKeyID=YOUR_AK SecretAccessKey=YOUR_AK securityToken=YOUR_STOKEN workspaceId=YOUR_WORKSPACE endpointId=YOUR_ENDPIONT_ID lakeformation_instance_id=YOUR_LF_ID PGDBNAME=YOUR_CATALOG
You do not need to set the username and password.
Property Name
Description
Mandatory or Optional
How to Obtain
AccessKeyID
Authentication ID
Mandatory
Creating a Permanent Access Key or Obtaining Temporary Access Keys and Security Tokens of an IAM User
SecretAccessKey
Authentication key
Mandatory
securityToken
STSToken
Optional (required when a temporary AK/SK pair is used.)
workspaceId
Workspace ID
Mandatory
Click View Details in Workspace Management Console.
endpointId
Endpoint ID
Mandatory
lakeformation_instance_id
LakeFormation instance ID
Mandatory
LakeFormation information created in Planning and Creating a LakeFormation Instance, Catalog, Database, and Table.
PGDBNAME
Lakeformation catalog name
Mandatory
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot