Halfpipe v0.2.4

In this release, Halfpipe comes with Oracle, SQL Server and ODBC driver support. Also the ability to run in AWS Lambda and perform data validation.

Release Notes

• Open-sourced the code using MIT licence

General

• Oracle and ODBC functionality is provided via plugins, while SQL Server support only requires the hp binary.
• The Oracle plugin hp-oracle-plugin.so is compiled against Oracle Database 19.8 client libraries, which is backwards compatible with older Oracle versions
• The ODBC plugin hp-odbc-plugin.so uses unixODBC libraries

Halfpipe v0.2.3

In this release, Halfpipe comes with Oracle, SQL Server and ODBC driver support. Also the ability to run in AWS Lambda and perform data validation.

Release Notes

• Improved ability of the diff action to handle different data types
• Prefer loading plugins from the current directory before checking /usr/local/lib

General

• Oracle and ODBC functionality is provided via plugins, while SQL Server support only requires the hp binary.
• The Oracle plugin hp-oracle-plugin.so is compiled against Oracle Database 19.8 client libraries, which is backwards compatible with older Oracle versions
• The ODBC plugin hp-odbc-plugin.so uses unixODBC libraries

The Oracle drivers are omitted from the base image due to licence restrictions, but you can choose the Quick Start mentioned below to easily build yourself a Docker image that includes them and the unixODBC drivers.

Options to get going:

• Quick Start - fire up a Docker image with Oracle client included
• Manual Setup - bring your own Oracle client

Halfpipe v0.2.0

In this release, Halfpipe comes with Oracle, SQL Server and ODBC driver support. Also the ability to run in AWS Lambda and perform data validation.

Release Notes

• Added diff capability to compare and validate data across source and target tables
• Added ability to delete database connections and default flag values - see the config command
• BREAKING CHANGE: Database connections created by previous versions of the tool are no longer compatible with this version. Please delete and re-add database connections to get going.

General

• Oracle and ODBC functionality is provided via plugins, while SQL Server support only requires the hp binary.
• The Oracle plugin hp-oracle-plugin.so is compiled against Oracle Database 19.8 client libraries, which is backwards compatible with older Oracle versions
• The ODBC plugin hp-odbc-plugin.so uses unixODBC libraries

The Oracle drivers are omitted from the base image due to licence restrictions, but you can choose the Quick Start mentioned below to easily build yourself a Docker image that includes them and the unixODBC drivers.

Options to get going:

• Quick Start - fire up a Docker image with Oracle client included
• Manual Setup - bring your own Oracle client

Halfpipe v0.1.6

In this release, Halfpipe comes with Oracle, SQL Server and ODBC driver support. Also the ability to run in AWS Lambda.

• Oracle and ODBC functionality is provided via plugins, while SQL Server support only requires the hp binary.
• The Oracle plugin hp-oracle-plugin.so is compiled against Oracle Database 19.8 client libraries, which is backwards compatible with older Oracle versions
• The ODBC plugin hp-odbc-plugin.so uses unixODBC libraries

The Oracle drivers are omitted from the base image due to licence restrictions, but you can choose the Quick Start mentioned below to easily build yourself a Docker image that includes them and the unixODBC drivers.

Options to get going:

• Quick Start - fire up a Docker image with Oracle client included
• Manual Setup - bring your own Oracle client

Halfpipe v0.1.5

In this release, Halfpipe comes with Oracle, SQL Server and ODBC driver support.

• Oracle and ODBC functionality is provided via plugins, while SQL Server support only requires the hp binary.
• The Oracle plugin hp-oracle-plugin.so is compiled against Oracle Database 19.8 client libraries, which is backwards compatible with older Oracle versions
• The ODBC plugin hp-odbc-plugin.so uses unixODBC libraries

The Oracle drivers are omitted from the base image due to licence restrictions, but you can choose the Quick Start mentioned below to easily build yourself a Docker image that includes them and the unixODBC drivers.

Options to get going:

• Quick Start - fire up a Docker image with Oracle client included
• Manual Setup - bring your own Oracle client

Halfpipe v0.1.4

In this release, Halfpipe is compiled against Oracle Database 19.5 client drivers, which is backwards compatible with older Oracle versions. The drivers are omitted due to Oracle licence restrictions, but you can choose the Quick Start mentioned below to easily build yourself a Docker image that includes them.

Options to get going:

• Quick Start - fire up a Docker image with Oracle client included
• Manual Setup - bring your own Oracle client

Halfpipe v0.1.1

Initial release based on Docker image relloyd/halfpipe-oracle-19.5-no-oci:1.

In this release, Halfpipe is compiled against Oracle Database 19.5 client drivers, which is backwards compatible with older Oracle versions. The drivers are omitted due to Oracle licence restrictions but you can use the start-halfpipe.sh script mentioned below to easily build yourself a Docker image that includes them.

I'm working on a sign-up process for Halfpipe, but in the meantime, if you'd like to take it for a spin, please get in touch directly at any time by email (richard at halfpipe dot sh) so I can create you an auth token.

Choose one of these options to get going.

Quickstart (Docker image with Oracle client included)...

Clone this repo and run script start-halfpipe.sh to re-add the Oracle drivers and create yourself a new local halfpipe Docker image. This is the easy option that drops you into a command prompt ready to use the hp CLI; or...

Bring your own Oracle client...

Download one of the attached binaries and add it to your target environment. You'll need the Oracle Instant Client installed and on your PATH. If you get an error like hp: error while loading shared libraries: libclntsh.so.19.1: cannot open shared object file: No such file or directory ensure your ORACLE_HOME environment variable set and the OCI library is accessible. If you follow Oracle's Instant Client set-up instructions and check that SQL*Plus works, you should be good to go