Db links in Vertica?
Moderator: NorbertKrupa
- abeeshdreams
- Newbie
- Posts: 7
- Joined: Tue Jul 10, 2012 6:11 am
Db links in Vertica?
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?
Abeeshdreams
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Db links 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:
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
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
- abeeshdreams
- Newbie
- Posts: 7
- Joined: Tue Jul 10, 2012 6:11 am
Re: Db links in Vertica?
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!
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!
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Db links in Vertica?
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?
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?
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: Db links in Vertica?
#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..
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..
Re: Db links in Vertica?
Hi Jim,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?
They are two different vertica databases.
thanks