Overview

The Database Connections allow us to use SQL queries to retrieve data, and subsequently use that data for natural language processing with TableUnderstanding or TablePrep.

IBM DB2

{{ db2|query:"your db2 query" | DATABASE: "" | HOSTNAME: "" | UID: "" | PWD: "" | PORT: "" | SECURE: "true" | sentences: "true"}}

Parameters:

• Query: The SQL query to pass to DB2. Double quotes must be escaped \" \" to pass through to DB2.
• DATABASE: The database name.
• HOSTNAME: The hostname of the DB2 instance.
• UID: The user ID to use for authentication.
• PWD: The user password for authentication.
• PORT: The port number.
• SECURE: Set to true or false depending on the use of SSL.
• Sentences: To return the query response in tabular format, set this to false. To return the response in natural language, set this to true.

Returns:

• If Sentences is set to true, returns results in natural language description similar to TablePrep.
• If Sentences is set to false, returns the query response in tabular format.

MySQL / Others

{{ postgres | query:"" | uri: "" | sentences: "true" | rds: "false"}}
{{ mariadb | query:"" | uri: "" | sentences: "true"}}
{{ mysql | query:"" | uri: "" | sentences: "true"}}
{{ mssql | query:"" | uri: "" | sentences: "true"}}
{{ oracle | query:"" | uri: "" | sentences: "true"}}
{{ redshift | query:"" | uri: "" | sentences: "true"}}

Parameters:

• Query: The SQL query to use. Double quotes must be escaped \" \" to pass through.
• URI: The connection URI. The preceding "mysql://" is not required.
• Sentences: To return the query response in tabular format, set this to false. To return the response in natural language, set this to true.
• RDS: For Postgres only - Only enable this if using RDS Proxy in front of Postgres.

Returns:

• If Sentences is set to true, returns results in natural language description similar to TablePrep.
• If Sentences is set to false, returns the query response in tabular format.