PHPackages                             mixartemev/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. mixartemev/dbal-vertica-driver

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

mixartemev/dbal-vertica-driver
==============================

Doctrine DBAL driver for Vertica

v1.3.3(1y ago)416.9k11MITPHPPHP >=7.4

Since Dec 6Pushed 1y ago2 watchersCompare

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

READMEChangelog (3)Dependencies (7)Versions (12)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.4
- php\_odbc extension
- Vertica drivers
- Doctrine >=2 DBAL

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

[](#installation)

*Case for Ubuntu / Debian*

##### Vertica drivers:

[](#vertica-drivers)

```
# Download official Vertica ODBC driver
curl -OL https://www.vertica.com/client_drivers/12.0.x/12.0.4-0/vertica-client-12.0.4-0.x86_64.tar.gz

# Extract & install it
sudo tar -xvzf vertica-client-12.0.4-0.x86_64.tar.gz -C /

# Set config files
sudo printf "[VerticaDev]\nDriver = /opt/vertica/lib64/libverticaodbc.so\nPort = 5433\nDriver = Vertica" > /etc/odbc.ini
sudo printf "[Vertica]\nDriver = /opt/vertica/lib64/libverticaodbc.so" > /etc/odbcinst.ini
sudo printf "[Driver]\nDriverManagerEncoding=UTF-16\nODBCInstLib = /usr/lib/x86_64-linux-gnu/libodbcinst.so.1\nErrorMessagesPath=/opt/vertica/lib64\nLogLevel=4\nLogPath=/tmp" > /etc/vertica.ini
```

##### PHP extentions & ODBC unix client:

[](#php-extentions--odbc-unix-client)

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

##### PDO Connector compatible with Doctrine 2 DBAL:

[](#pdo-connector-compatible-with-doctrine-2-dbal)

```
composer require mixartemev/dbal-vertica-driver
```

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)

```