The Vertica Database Forums

I'm a newbie. I would like to know if there is any concept like "db link" available in Vertica ? If not can anyone please teach me how to inter connect two db's in Vertica?

Hi,

Welcome to the forums!

Are you trying to link Vertica to a non-Vertica database? Unfortunately, as far as I know (as of Vertica 6) we can not create database links like those that exist in Oracle and SQL Server.

But we can easily connect to another Vertica database if we need to to copy data between two Vertica databases. See page 665 of the SQL Reference Manual:

CONNECT TO VERTICA database USER username PASSWORD 'password' ON 'host',port

Thanks a lot knicely87. That helped

Hi,
I am new to this forum and Vertica as well. We are running version 6. I am designing an in house ETL process . I have the need to join 2 tables in vertica that belong to 2 different databases.
Is there a way to do that? I could do that over dblinks in oracle/sqlserver.



thanks for the help!

Hi!

What do you mean by "I have the need to join 2 tables in vertica that belong to 2 different databases"? Are they two different Vertica databases or are they disparate databases?

#DGh

Welcome to Vertica Forums !

As of now, DB links feature in not present in Vertica.
More over you cannot run two databases simultaneously at one time in Vertica cluster.

The approach to your scenario can be : use two different schemas in same cluster which can act as two different database.
Once the databases are set, you can join the tables in two different database using the standard SQL.

Let us know your requirement precisely..

Hope this helps..

knicely87 wrote:Hi!

What do you mean by "I have the need to join 2 tables in vertica that belong to 2 different databases"? Are they two different Vertica databases or are they disparate databases?

Hi Jim,
They are two different vertica databases.

thanks