com.twineworks:vertica-9-for-pentaho-kettle

Vertica 9+ support for pentaho kettle

License	Apache 2.0 License
GroupId	com.twineworks
ArtifactId	vertica-9-for-pentaho-kettle
Last Version	1.0
Release Date	Nov 25, 2017
Type	jar
Description	com.twineworks:vertica-9-for-pentaho-kettle Vertica 9+ support for pentaho kettle
Project URL	https://github.com/twineworks/vertica-9-for-pentaho-kettle
Project Organization	Twineworks GmbH
Source Code Management	https://github.com/twineworks/vertica-9-for-pentaho-kettle/tree/master

Download vertica-9-for-pentaho-kettle

Filename	Size
vertica-9-for-pentaho-kettle-1.0.pom
vertica-9-for-pentaho-kettle-1.0.jar	14 KB
vertica-9-for-pentaho-kettle-1.0-sources.jar	6 KB
vertica-9-for-pentaho-kettle-1.0-plugin.zip	19 KB
vertica-9-for-pentaho-kettle-1.0-javadoc.jar	29 KB

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/com.twineworks/vertica-9-for-pentaho-kettle/ -->
<dependency>
    <groupId>com.twineworks</groupId>
    <artifactId>vertica-9-for-pentaho-kettle</artifactId>
    <version>1.0</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/com.twineworks/vertica-9-for-pentaho-kettle/
implementation 'com.twineworks:vertica-9-for-pentaho-kettle:1.0'

Gradle Kotlin

// https://jarcasting.com/artifacts/com.twineworks/vertica-9-for-pentaho-kettle/
implementation ("com.twineworks:vertica-9-for-pentaho-kettle:1.0")

Apache Buildr

'com.twineworks:vertica-9-for-pentaho-kettle:jar:1.0'

Apache Ivy

<dependency org="com.twineworks" name="vertica-9-for-pentaho-kettle" rev="1.0">
  <artifact name="vertica-9-for-pentaho-kettle" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='com.twineworks', module='vertica-9-for-pentaho-kettle', version='1.0')
)

Scala SBT

libraryDependencies += "com.twineworks" % "vertica-9-for-pentaho-kettle" % "1.0"

Leiningen

[com.twineworks/vertica-9-for-pentaho-kettle "1.0"]

Dependencies

compile (1)

Group / Artifact	Type	Version
pentaho-kettle » kettle-core	jar	6.1.0.9-307

test (2)

Group / Artifact	Type	Version
org.assertj : assertj-core	jar	2.8.0
junit : junit	jar	4.12

Project Modules

There are no modules declared in this project.

Vertica 9+ compatibility plugin for pentaho-kettle

An plugin for Pentaho kettle (PDI) providing support for modern versions of Vertica. Tested with Vertica 9.

Supported versions of pentaho-kettle

The plugin is built against the most recent versions of Kettle 6.x, 7.x and 8.x.

How to get it?

Grab the latest release from the releases page. You can also get the plugin zip as a maven dependency from maven central.

How to install?

Decompress the release zip to <kettle-dir>/plugins and restart Spoon. The "Vertica 9+" database type will appear in the "Database Connection" dialogs. You still need to supply your own JDBC driver for vertica. The plugin is tested with the official vertica 9 jdbc drivers.

Why would I want this?

Official Vertica support in kettle has not been updated in a while. Among other things, this plugin fixes the following issues:

• PDI-7769 - Vertica: Database Explorer shows views in the schema tree instead of the view tree
• PDI-10234 - Vertica database logging does not log time information (In fact, the issue is more severe: time is always truncated in DATETIME inserts.)
• PDI-13018 - lazy conversion for vertica table input does not work
• PDI-12040 - Getting data of TIME type from Vertica DB (or sending to Vertica DB) is failed with the errors from Vertica JDBC
• PDI-16462 - Support for Vertica 8 (Sort of, the plugin is tested against Vertica 9. If anybody wants to try on 8, there's a good chance it's going to work just fine.)

Where do I report bugs and issues?

Just open issues on github.

How do I build the project?

mvn clean package

It creates the plugin zip in target/vertica-9-for-pentaho-kettle-{version}-plugin.zip.

How can I contribute?

If you'd like to contribute please fork the project, add the feature or bugfix and send a pull request.

License

The plugin uses the Apache 2.0 license. Same as kettle.

Support

Open source does not mean you're on your own. The plugin is developed by Twineworks GmbH. Twineworks offers commercial support and consulting services. Contact us if you'd like us to help with a project.

Twineworks GmbH

Versions

Version
1.0 Nov 25, 2017