Skip to main content
Skip table of contents

RDBMS database providers

Overview

NEW IN 9.6.1 Redpoint Data Management v9.6.1 introduces a next-generation set of database providers. These next-generation data providers were rewritten to be more robust and performant. The next-generation data providers feature the following:

  • Bulk load for MS SQL Server and Azure SQL.

  • Bulk load and bulk query support for Azure Synapse and Snowflake.

  • Greatly simplified configuration options with optimized defaults.

  • Tested and qualified JDBC drivers included with product updates.

RPDM v9.6.1 introduces next-generation data providers for:

  • We’ll continue to add new next-generation data providers in upcoming RPDM releases.

  • We’re designating the previous generation of data providers as “legacy” to differentiate them; however, they’re not specifically deprecated at this point, unless noted otherwise.

  • We recommend that you migrate to next-generation providers, where available, to take advantage of the performance and simplification improvements. However, it is possible that you may find some minor behavior incompatibilities between these and the legacy providers. Always test before committing to the change.

The following table summarizes the RDBMS providers available:

RDBMS provider

Connection methods

Notes

AWS (Aurora and Redshift)

JDBC | ODBC*

Azure

JDBC | ODBC* | OLE DB*

NEW IN 9.6.1: next-generation providers for:

  • Azure Synapse with bulk load and bulk query support

  • Azure SQL with bulk load support

DB2

JDBC | ODBC*

Excel

OLE DB*

Deprecated

Generic

OLE DB* or ODBC*

Deprecated

Google BigQuery

JDBC

MySQL

JDBC | ODBC*

Netezza

JDBC | ODBC*

Oracle

JDBC

PostgreSQL

JDBC | ODBC*

SAP HANA

JDBC

Snowflake

JDBC

NEW IN 9.6.1: next-generation provider for Snowflake with bulk load and bulk query support

SQL Server

JDBC

NEW IN 9.6.1: next-generation provider for Microsoft SQL Server with bulk load support

Sybase

JDBC | ODBC*

Teradata

JDBC | ODBC*

Vertica

JDBC | ODBC*

ODBC and OLE DB providers have been deprecated in Data Management and may not be supported in future versions.

Select a database

The Database selector is located on the Source tab of the RDBMS Input, RDBMS Output, RDBMS Execute, and Data Connection Properties pane.

image-20240327-151923.png

Use this control to select an RDBMS provider, which consists of:

  • A database type (such as Oracle, SQL Server, or DB2).

  • A connection method (JDBC preferred; OleDB, ODBC, and Oracle OLI are deprecated and will not be supported in future Data Management releases).

  • A set of read-only parameters that further refine the database strategy.

  • A set of options appropriate for the database strategy. Default options are displayed on the Options tab but can be overridden.

  • A set of parameters to be defined in that typically specify the database server, database name, and initial catalog.

Database providers simplify the task of connecting to different databases by predefining parameters, selecting appropriate options, and setting up a fill-in-the-blank grid for defining necessary parameters. Data Management ships with a selection of database providers organized by database type.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.