How to connect Amazon Redshift to Generic ODBC/JDBC tools

Discover how to connect Amazon Redshift to Generic ODBC/JDBC tools and how to integrate Amazon Redshift with other data sources to build an organization-wide data model.

WITH DATA VIRTUALITY PIPES
Replicate your data sources into Amazon Redshift and analyze it with Generic ODBC/JDBC tools.
How to connect Amazon Redshift to Generic ODBC/JDBC tools with Pipes


About Amazon Redshift

Amazon Redshift is a data warehouse that allows its users to analyze data in conjunction with existing Business Intelligence tools and standard SQL. With Amazon Redshift users are enabled to perform complex analysis queries on multiple petabytes of structured data.

About Generic ODBC/JDBC tools

Generic ODBC/JDBC tools are used for creating, managing, archiving, and extracting simple or complex databases. Some of these tools have been developed specifically for the Mac OS X and Linux operating systems, other tools cover all other operating systems (e.g., Windows) and database systems (for example, MySQL, PostgreSQL, Oracle). Due to the constant extensions, the Generic ODBC/JDBC tools are offered as test versions over shorter or longer periods for cloud databases.

MOVE YOUR DATA WITH PIPES

Pipes allows you to connect to Amazon Redshift, Generic ODBC/JDBC tools and more than 200 other cloud services and databases. Automate your data workflows with data pipelines.

DATA VIRTUALITY OFFERS TWO PIPES SOLUTIONS

depending on your needs.

Pipes

Easy and reliable data replication in the cloud

Pipes enables you to move data from any data source to your target storage or data warehouse on schedule. Integrate your data with just a few clicks and without any coding.

Pipes Professional

Advanced data replication hosted in the cloud or on-premises

Pipes Professional enables you to transform and model your data with SQL before replication. Customize your data pipelines and build data models across sources in 80% less time.

Pipes Professional features include:

  • SQL Modelling Layer
  • Complex Replication Types
  • Advanced Jobs & Schedules
  • Metadata Repositories
  • Custom Extraction Definitions
  • Job Dependencies
  • Multiple Target Storages
  • Data Federation Features
  • Custom Job Triggers
Your future with automated data workflows is only a few clicks away.