How to connect to a Redshift database in a Symfony application

Question

I am working on an application built using Symfony3 which needs to retrieve data from a Redshift database.

How can I go about achieving this? Appreciate any assistance.

Answer 1

I figured it out by following the Symfony documentation to configure mulitple entity managers.

My issue was that I was specifying the incorrect driver. This should be 'pdo_pgsql'.

I installed the driver on my system by following the steps in the first answer and comments in this question

Answer 2

You can use this bundle awsBundle by Farhad Safarov.

Follow the instuctions to install and configure the bundle with your application then use it (example from the README.md):

// AWS S3 example
public function someAction()
{
    $client = $this->get('aws.s3');

    // Upload an object to Amazon S3
    $result = $client->putObject(array(
        'Bucket' => $bucket,
        'Key'    => 'data.txt',
        'Body'   => 'Hello!'
    ));
    // ...
}