Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Untuk menggunakan Looker dengan Actian Avalanche atau Vector, Anda harus mengonfigurasi driver Ingres. Petunjuk ini menjelaskan proses tersebut, dengan asumsi penggunaan skrip startup yang mirip dengan contoh yang disediakan di halaman GitHub looker-open-source.
Anda harus mendapatkan JAR driver Ingres, menyertakannya sebagai bagian dari proses startup, dan menambahkan opsi untuk memberi tahu Looker agar mengaksesnya.
Mengenkripsi traffic jaringan
Praktik terbaiknya adalah mengenkripsi traffic jaringan antara aplikasi Looker dan database Anda. Pertimbangkan salah satu opsi yang dijelaskan di halaman dokumentasi Mengaktifkan akses database yang aman.
Ikuti langkah-langkah berikut untuk membuat koneksi dari Looker ke database Anda:
Di bagian Admin Looker, pilih Connections, lalu klik Add Connection.
Pilih Actian Avalanche atau Vector dari menu drop-down Dialek.
Isi detail koneksi. Sebagian besar setelan umum untuk sebagian besar dialek database. Lihat halaman dokumentasi Menghubungkan Looker ke database Anda untuk mengetahui informasi selengkapnya.
Untuk memverifikasi bahwa koneksi berhasil, klik Uji. Lihat halaman dokumentasi Menguji konektivitas database untuk mengetahui informasi pemecahan masalah.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-08-25 UTC."],[],[],null,["# Actian Avalanche and Vector\n\nTo use Looker with Actian Avalanche or Vector, you will need to configure an Ingres driver. These instructions describe that process, assuming use of a startup script that is similar to the examples that are provided on the [looker-open-source GitHub page](https://github.com/looker-open-source/customer-scripts/tree/master/startup_scripts).\n\nYou will need to acquire an Ingres driver JAR, include it as part of the startup process, and add an option to tell Looker to access it.\n\nEncrypting network traffic\n--------------------------\n\nIt is a best practice to encrypt network traffic between the Looker application and your database. Consider one of the options described on the [Enabling secure database access](/looker/docs/enabling-secure-db-access) documentation page.\n\nInstalling the Ingres JDBC driver\n---------------------------------\n\nFollow the steps on the [Unpackaged JDBC drivers](/looker/docs/unpackaged-jdbc-drivers) documentation page using the following values:\n\n**driver symbol** : `ingres`\n\n**driver entry**: \n\n - name: ingres\n dir_name: ingres\n module_path: com.ingres.jdbc.IngresDriver\n\nFor the [step to put the driver in your dialect's directory](/looker/docs/unpackaged-jdbc-drivers#driver_directory), the path to this file will look like this: `looker/custom_jdbc_drivers/ingres/iijdbc.jar`.\n\nCreating the Looker connection to your database\n-----------------------------------------------\n\nFollow these steps to create the connection from Looker to your database:\n\n1. In the **Admin** section of Looker, select **Connections** , and then click **Add Connection**.\n2. Select **Actian Avalanche** or **Vector** from the **Dialect** drop-down menu.\n\n | **Note:** If you are on a [Looker (Google Cloud core)](/looker/docs/looker-core-overview) instance and you don't see your dialect listed in the **Dialect** drop-down menu, see the [Looker (Google Cloud core) documentation](/looker/docs/looker-core-dialects#supported_dialects_for) to verify that the dialect is supported for Looker (Google Cloud core) instances.\n3. Fill out the connection details. The majority of the settings are common to most database dialects. See the [Connecting Looker to your database](/looker/docs/connecting-to-your-db) documentation page for information.\n\n4. To verify that the connection is successful, click **Test** . See the [Testing database connectivity](/looker/docs/testing-db-connectivity) documentation page for troubleshooting information.\n\n5. To save these settings, click **Connect**.\n\nEnabling PDT support\n--------------------\n\nIt is possible to use [persistent derived tables (PDTs)](/looker/docs/derived-tables#persistent_derived_table) on your database using the [**PDT Overrides**](/looker/docs/connecting-to-your-db#configuring_separate_login_credentials_for_pdt_processes) section in the [**Connection Settings** page](/looker/docs/admin-panel-database-connections#adding_connections).\n\nTo enable PDTs:\n\n1. Create a PDT user in your database for use with the scratch schema, for example `looker_scratch`.\n\n2. Create a group in your database such as `looker_pdt_group`.\n\n3. Add both the regular Looker user and the Looker PDT user to the new group.\n\n4. GRANT SELECT on all tables in the regular Looker user's schema to the PDT user.\n\n5. In the Looker **Connection Settings** page, in the **PDT Overrides** section, enter the PDT user information.\n\n6. The PDT user then runs a GRANT SELECT to the `looker_pdt_group` for every table it creates.\n\nFeature support\n---------------\n\nFor Looker to support some features, your database dialect must also support them.\n\n### Actian Avalanche\n\nActian Avalanche supports the following features as of Looker 25.14:\n\n### Vector\n\nVector supports the following features as of Looker 25.14:"]]
