PHPackages                             rezon73/dbal-vertica-driver - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. rezon73/dbal-vertica-driver

ActiveLibrary[Database & ORM](/categories/database)

rezon73/dbal-vertica-driver
===========================

Doctrine DBAL driver for Vertica in Laravel

1.4.3(5y ago)0691MITPHPPHP >=7.4

Since Dec 6Pushed 5y agoCompare

[ Source](https://github.com/rezon73/dbal-vertica-driver)[ Packagist](https://packagist.org/packages/rezon73/dbal-vertica-driver)[ Docs](https://github.com/rezon73/dbal-vertica-driver)[ RSS](/packages/rezon73-dbal-vertica-driver/feed)WikiDiscussions master Synced today

READMEChangelog (4)Dependencies (7)Versions (14)Used By (0)

DBAL Vertica driver
===================

[](#dbal-vertica-driver)

Doctrine DBAL connector driver for Vertica. *Ready for use in **Laravel** / Lumen*

Requirements
------------

[](#requirements)

- php >= 7.2
- php\_odbc extension
- Vertica drivers
- Doctrine 2 DBAL

Installation
------------

[](#installation)

##### PHP extentions:

[](#php-extentions)

```
apt-get install php-odbc php-pdo php-json
```

##### Vertica drivers:

[](#vertica-drivers)

Make ODBC and Vertica drivers to work together:

- Download and extract Vertica drivers from official website  (it should match your Vertica Db version)
- Extract driver under /opt/vertica/
- create/edit file: /etc/odbc.ini ([example](https://github.com/skatrych/vertica-php-adapter/blob/master/examples/drivers/odbc.ini))
- create/edit file: /etc/odbcinst.ini ([example](https://github.com/skatrych/vertica-php-adapter/blob/master/examples/drivers/odbcinst.ini))
- create/edit file: /etc/vertica.ini ([example](https://github.com/skatrych/vertica-php-adapter/blob/master/examples/drivers/vertica.ini))

##### All the rest:

[](#all-the-rest)

- Add to your composer.json:

```
    "repositories": [
        {
            "type": "vcs",
            "url": "https://github.com/rezon73/dbal-vertica-driver.git"
        }
    ]
```

```
composer install
```

Integration in Laravel
----------------------

[](#integration-in-laravel)

##### .env

[](#env)

```
DB_HOST_VERTICA=127.0.0.1
#DB_PORT_VERTICA=5433 (DONT SET PORT! IT MUST BE EXACTLY INTEGER! GETTING FROM dafaults in )
DB_DATABASE_VERTICA=dbname
DB_USERNAME_VERTICA=username
DB_PASSWORD_VERTICA=password

```

##### config/database.php

[](#configdatabasephp)

```