Vertica Integration with ScoreFast: Connection Guide
Applies to Vertica 7.0.x and earlier
About Vertica Connection Guides
Vertica connection guides provide basic information about setting up connections to Vertica from software that our technology partners create. These documents provide guidance using one specific version of Vertica and one specific version of the third-party vendor’s software. Other versions of the third-party product may work with Vertica. However, other versions may not have been tested. This document provides guidance using the latest versions of Vertica and ScoreFast on Amazon cloud as of July 2016.
ScoreFast is a predictive analytics platform designed for public and private cloud deployments. ScoreFast provides a wide range of machine-learned algorithms and models to meet your business needs and automate the process of deploying models into run-time environments using an API. ScoreFast also provides dashboards for data audits and model performance.
ScoreFast now supports Vertica as a source through which you can load data and build models. ScoreFast connects to Vertica using the Vertica 7.0.x JDBC driver, which is embedded in the ScoreFast platform. You can connect to Vertica on the ScoreFast cloud or by running on a public IP address. ScoreFast has to be deployed on-premises for connecting Vertica instances running behind firewalls.
This document is based on the results of testing the Vertica 7.x JDBC Driver with ScoreFast deployed on ScoreData's cloud.
To get the account and licenses for using ScoreData's cloud platform to test Vertica as a source, contact ScoreData.
Connect Vertica to ScoreFast using JDBC
To connect your Vertica database to ScoreFast, complete the following steps.