Skip to content

Database connections

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.