CODEWITHSUNDEEP
phpvertica
tandy
tandy

Reputation: 1948

Connecting to a Vertica DB with PHP

Is there a way to connect to a Vertica database with PHP -- a function similar to mysql_connect()?

I'm ultimately trying to write a script that pulls data from a Vertica database and stores it in a localhost MySQL database.

If necessary, I would be willing to work with Python to make this happen.

Upvotes: 2

Views: 3895

Answers (2)

deadrunk
deadrunk

Reputation: 14135

Also you can use a Postgres client libraries to connect to Vertica instance.

Upvotes: 2

bpanulla
bpanulla

Reputation: 2998

The PHP ODBC module (classic or PDO) works fine for Vertica connections. You'll need to download the appropriate ODBC driver for your Vertica version from the My Vertica portal and install it on your PHP server.

Upvotes: 4

Related Questions