connecting vertica on AWS using php
I have been able to connect to my local vertica instance using php leveraging UNIX ODBC pacakge. I used a code similar to this one.
$dbName = 'your-database-name';
$hostname = 'your-hostname.com;
$account = 'your-username';
$password = 'your-password';
$driver = 'Vertica';
$dsn = 'Driver='.$driver.';Server='.$hostname.';Database='.$dbName;
$pdo = new PDO('odbc:'.$dsn, $account, $password);
Now I have moved my vertica database to the AWS. How do I connect to the vertica localed in AWS using php? What password shall I use since AWS EC2 does not allow vertica install with password.
Can anyone please share some example ?