isabella232 / gosql-driver Goto Github PK

Teradata GoSQL Driver Plugin

The Teradata GoSQL Driver is available as a Go plugin.

This is not an official Teradata supported product. This plugin is provided as a service to the user community for accessing Teradata Vantage from the Go language.

Please be aware that Go plugins currently have significant limitations from the Go language itself.

• Only macOS and Linux support, but no Windows support.
• Go plugins can only be used with the specific version of Go that was used to build the plugin. No forward or backward compatibility across Go language versions.

This Go plugin requires 64-bit Go 1.14.6, and runs on macOS and Linux.

For community support, please visit the Teradata Community forums.

Please note, this driver may contain beta/preview features ("Beta Features"). As such, by downloading and/or using the driver, in addition to agreeing to the licensing terms below, you acknowledge that the Beta Features are experimental in nature and that the Beta Features are provided "AS IS" and may not be functional on any machine or in any environment.

Copyright 2020 Teradata. All Rights Reserved.

Table of Contents

• Download
• License
• Sample Program
• Connection Parameters
• Data Types

Download

Download the shared library for your platform.

• For macOS, download teradatasql-go1.14.6.dylib

• For Linux, download teradatasql-go1.14.6.so

License

Use of the Teradata GoSQL Driver is governed by the License Agreement for the Teradata GoSQL Driver.

In addition to the license terms, the driver may contain beta/preview features ("Beta Features"). As such, by downloading and/or using the driver, in addition to the licensing terms, you acknowledge that the Beta Features are experimental in nature and that the Beta Features are provided "AS IS" and may not be functional on any machine or in any environment.

Sample Program

The sample program UseGoSQLPlugin.go demonstrates how to load the Teradata GoSQL Driver plugin and use the Teradata GoSQL Driver.

The Teradata GoSQL Driver accepts a JSON string to specify connection parameters, documented below.

You must properly quote the UseGoSQLPlugin.go command line arguments for the JSON string and the SQL query text parameters according to what your shell requires.

In the following example, single-quotes are used to enclose the JSON string, which contains double-quotes. This is the typical quoting style on macOS and Linux. Specify your platform's shared library filename as the first argument after the UseGoSQLPlugin.go filename argument.

go run UseGoSQLPlugin.go teradatasql-go1.14.6.dylib '{"host":"whomooz","user":"guest","password":"please"}' "select 123"

The QueryRows.go program can execute multiple SQL requests using the same database connection.

go run UseGoSQLPlugin.go teradatasql-go1.14.6.dylib '{"host":"whomooz","user":"guest","password":"please"}' "create volatile table tomtab1 (c1 integer) on commit preserve rows" "insert into tomtab1 values(123)" "select * from tomtab1"

This is different from executing a multi-statement request in which multiple DML statements are separated by semicolons.

go run UseGoSQLPlugin.go teradatasql-go1.14.6.dylib '{"host":"whomooz","user":"guest","password":"please"}' "help session ; select current_timestamp ; select * from dbc.dbcinfo"

Teradata GoSQL Driver Connection Parameters

The Teradata GoSQL Driver accepts a JSON string to specify connection parameters.

The connection parameter string must be formatted as a JSON object with open and close curly braces containing key-value pairs, with both the keys and the values being JSON strings.

Example: {"host":"dbserver.foo.com","user":"guest","password":"please"}

We want to provide consistency for Teradata JDBC Driver and Teradata GoSQL Driver connection parameters, in terms of both connection parameter names and functionality. We want the Teradata GoSQL Driver to offer all the same connection parameters that the Teradata JDBC Driver offers, for those connection parameters that make sense outside of Java.

Here is the current list of the Teradata GoSQL Driver's JSON string connection parameters, and their default values if omitted.

Data Types