PHPackages                             avia-avian/laravel-dremio-odbc - 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. avia-avian/laravel-dremio-odbc

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

avia-avian/laravel-dremio-odbc
==============================

Laravel driver for Dremio via ODBC or REST API.

v1.0.8(1mo ago)040↓50%MITPHPPHP ^8.0

Since Aug 28Pushed 1mo agoCompare

[ Source](https://github.com/avia-avian/laravel-dremio-odbc)[ Packagist](https://packagist.org/packages/avia-avian/laravel-dremio-odbc)[ RSS](/packages/avia-avian-laravel-dremio-odbc/feed)WikiDiscussions main Synced 1mo ago

READMEChangelogDependencies (6)Versions (10)Used By (0)

Laravel Dremio Driver (ODBC + API)
==================================

[](#laravel-dremio-driver-odbc--api)

[![Latest Stable Version](https://camo.githubusercontent.com/bb9215d2829dcbd0602a96f8b68bed9c31e6eadd31793c896d499cc5a5558a0f/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f617669612d617669616e2f6c61726176656c2d6472656d696f2d6f6462632e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/avia-avian/laravel-dremio-odbc)[![Total Downloads](https://camo.githubusercontent.com/573c16d1fb475fbe8dfc7bb3951e2f251edcc835fcf7ddeaecb33e781e6e184d/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f617669612d617669616e2f6c61726176656c2d6472656d696f2d6f6462632e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/avia-avian/laravel-dremio-odbc)[![License](https://camo.githubusercontent.com/cad61bd7d6913ee5d687668781775af0223940714bf43560a4ab078339764d14/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f6c6963656e73652f617669612d617669616e2f6c61726176656c2d6472656d696f2d6f6462633f7374796c653d666c61742d737175617265)](LICENSE)

Integrasi **Laravel Database Connection** dengan **Dremio** menggunakan dua mode transport:

- **ODBC** (Arrow Flight SQL ODBC)
- **API** (Dremio REST SQL endpoint)

Package ini memudahkan Laravel untuk memilih mode koneksi sesuai kebutuhan deployment.

---

🚀 Prasyarat
-----------

[](#-prasyarat)

Jika memakai mode **ODBC**, pastikan sudah menginstal **Dremio ODBC Driver** di server lokal atau server aplikasi:

- [📥 Download Dremio ODBC Driver (Windows, macOS, Linux)](https://www.dremio.com/drivers/)

---

📦 Instalasi
-----------

[](#-instalasi)

Tambahkan package ke project Laravel:

```
composer require avia-avian/laravel-dremio-odbc
```

---

⚙️ Konfigurasi
--------------

[](#️-konfigurasi)

### 1. Pilih mode koneksi di `.env`

[](#1-pilih-mode-koneksi-di-env)

Pilih salah satu:

```
DREMIO_CONNECTION=odbc
```

atau

```
DREMIO_CONNECTION=api
```

### 2A. Konfigurasi mode ODBC di `.env`

[](#2a-konfigurasi-mode-odbc-di-env)

```
DREMIO_DRIVER="Arrow Flight SQL ODBC Driver"
DREMIO_HOST=127.0.0.1
DREMIO_PORT=32010
DREMIO_DATABASE=AVIAN
DREMIO_ENCRYPTION=1
DREMIO_DISABLE_CERTIFICATE_VERIFICATION=1
DREMIO_USERNAME=software.engineer
DREMIO_PASSWORD=secret
```

### 2B. Konfigurasi mode API di `.env`

[](#2b-konfigurasi-mode-api-di-env)

Autentikasi bisa pakai **token** atau **username/password** (pilih salah satu):

```
DREMIO_API_BASE_URL=https://dremio.example.com

# Opsi 1: Pakai Personal Access Token
DREMIO_API_TOKEN=your_personal_access_token

# Opsi 2: Pakai Username & Password (auto-login)
DREMIO_API_USERNAME=software.engineer
DREMIO_API_PASSWORD=secret

DREMIO_API_SQL_ENDPOINT=/api/v3/sql
DREMIO_API_LOGIN_ENDPOINT=/apiv2/login
DREMIO_API_TIMEOUT=30
DREMIO_API_VERIFY_SSL=true
# optional: JSON array context
DREMIO_API_CONTEXT=["mySpace","myFolder"]
```

### 3. Tambahkan konfigurasi di `config/database.php`

[](#3-tambahkan-konfigurasi-di-configdatabasephp)

```
'connections' => [

    // ... koneksi database lain

    'dremio' => [
        'driver'   => 'dremio',
        'connection' => env('DREMIO_CONNECTION', 'odbc'),

        // ODBC
        'dsn'      => env('DREMIO_DRIVER', 'Arrow Flight SQL ODBC Driver'),
        'host'     => env('DREMIO_HOST', '127.0.0.1'),
        'port'     => env('DREMIO_PORT', '32010'),
        'username' => env('DREMIO_USERNAME'),
        'password' => env('DREMIO_PASSWORD'),
        'database' => env('DREMIO_DATABASE', 'AVIAN'),
        'encryption' => env('DREMIO_ENCRYPTION', 1),
        'disable_cert_verification' => env('DREMIO_DISABLE_CERTIFICATE_VERIFICATION', 1),

        // API
        'api_base_url' => env('DREMIO_API_BASE_URL', ''),
        'api_token' => env('DREMIO_API_TOKEN', ''),
        'api_username' => env('DREMIO_API_USERNAME', ''),
        'api_password' => env('DREMIO_API_PASSWORD', ''),
        'api_login_endpoint' => env('DREMIO_API_LOGIN_ENDPOINT', '/apiv2/login'),
        'api_sql_endpoint' => env('DREMIO_API_SQL_ENDPOINT', '/api/v3/sql'),
        'api_timeout' => env('DREMIO_API_TIMEOUT', 30),
        'api_verify_ssl' => env('DREMIO_API_VERIFY_SSL', true),
        'api_context' => env('DREMIO_API_CONTEXT', null),
    ],

],
```

### 4. Registrasi Service Provider (Laravel < v11)

[](#4-registrasi-service-provider-laravel--v11)

Jika menggunakan **Laravel 11 ke atas**, package auto-discovery akan berjalan otomatis.
Namun untuk Laravel versi lama, tambahkan manual di `config/app.php`:

```
'providers' => [
    // Provider bawaan Laravel...
    App\Providers\AppServiceProvider::class,

    // Tambahkan ini:
    AviaAvian\DremioOdbc\Providers\OdbcServiceProvider::class,
],
```

### 5. Publish Config (opsional)

[](#5-publish-config-opsional)

Jika ingin mengubah konfigurasi default package, jalankan perintah:

```
php artisan vendor:publish --provider="AviaAvian\DremioOdbc\Providers\OdbcServiceProvider" --tag=config
```

Ini akan menghasilkan file `config/dremio_odbc.php` yang bisa kamu sesuaikan sesuai kebutuhan.

---

🛠️ Contoh Penggunaan
--------------------

[](#️-contoh-penggunaan)

Gunakan connection `dremio` seperti koneksi database biasa di Laravel:

```
$results = DB::connection('dremio')
    ->select('SELECT * FROM Samples."samples.dremio.com"."NYC-taxi-trips" LIMIT 10');

foreach ($results as $row) {
    dump($row);
}
```

---

❗ Troubleshooting
-----------------

[](#-troubleshooting)

### Error `Data source name not found`

[](#error-data-source-name-not-found)

Pastikan ODBC driver sudah diinstal dengan benar.

### Error SSL / Certificate

[](#error-ssl--certificate)

Atur variabel `.env`:

```
DREMIO_ENCRYPTION=1
DREMIO_DISABLE_CERTIFICATE_VERIFICATION=1
```

### Tidak bisa connect ke Dremio

[](#tidak-bisa-connect-ke-dremio)

Periksa apakah port `32010` terbuka dan service Dremio aktif.

### Error API (`Dremio API base URL is required`)

[](#error-api-dremio-api-base-url-is-required)

Pastikan saat `DREMIO_CONNECTION=api`, variabel `DREMIO_API_BASE_URL` sudah diisi.

---

📖 Dokumentasi Tambahan
----------------------

[](#-dokumentasi-tambahan)

- [Dremio Drivers](https://www.dremio.com/drivers/)
- [Laravel Database Connections](https://laravel.com/docs/master/database#configuration)

---

📄 License
---------

[](#-license)

MIT © Avia-Avian

###  Health Score

41

—

FairBetter than 89% of packages

Maintenance91

Actively maintained with recent releases

Popularity10

Limited adoption so far

Community9

Small or concentrated contributor base

Maturity46

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 66.7% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~27 days

Recently: every ~0 days

Total

9

Last Release

42d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/3a1d8814e786da2a1402326c00fb76d30218f0b46aa5b50ed217a91e3a6e02b8?d=identicon)[caktoy](/maintainers/caktoy)

![](https://www.gravatar.com/avatar/c06c9bcbc747f876ea83e873248687f438284b1801fdf783f74b7b8312974e51?d=identicon)[ikkosatrio](/maintainers/ikkosatrio)

---

Top Contributors

[![ikkosatrio](https://avatars.githubusercontent.com/u/17069028?v=4)](https://github.com/ikkosatrio "ikkosatrio (10 commits)")[![caktoy](https://avatars.githubusercontent.com/u/6917446?v=4)](https://github.com/caktoy "caktoy (5 commits)")

---

Tags

apilaraveldatabaseodbcdremio

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/avia-avian-laravel-dremio-odbc/health.svg)

```
[![Health](https://phpackages.com/badges/avia-avian-laravel-dremio-odbc/health.svg)](https://phpackages.com/packages/avia-avian-laravel-dremio-odbc)
```

###  Alternatives

[spiritix/lada-cache

A Redis based, automated and scalable database caching layer for Laravel

591444.8k2](/packages/spiritix-lada-cache)[ntanduy/cloudflare-d1-database

Easy configuration and setup for D1 Database connections in Laravel.

215.4k](/packages/ntanduy-cloudflare-d1-database)[dbt/odbc-driver

ODBC Driver for Laravel 12+

28137.1k](/packages/dbt-odbc-driver)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)