As saw seen in Chapter 3, Advanced Analytics – Paradigms, Tools, and Techniques, Weka is a Java-based analytics framework and an alternative to R. As it is a Java-based analytics API, it can connect to any database that supports or has a JDBC driver. Weka comes with a support to a wide range of database and in order to connect to Greenplum, we would need to use the
DatabaseUtils.props.postgresql properties file and should be extracted to the
To connect to Postgres/Greenplum from Weka, configure the following properties in the
DatabaseUtils.props.postgresql properties file:
jdbcDriver = org.postgresql.Driver jdbcURL= jdbc:postgresql://<<domain>>:<<port>>/<<dbName>>
Weka has an API
InstanceQuery that can be ...