Обсуждение: Distributed DataBases
Hi all,
I have some questions about postgreSQL, concerning Distributed DataBases.
I know Oracle can do this very Well. With Oracle, i can configure my dataBases to use data stored in another DataSource (Microsoft SQL Server, Access, Access, ...), using Oracle Transparent Gateway.
What i want to know is There is a way to configure PostgreSQL to do the same, or there is contrib/module that i can configure to do the same like Oracle Transparent Gateway.
It is important for me because in my company, there is many DataBases Stored in different SGBDR, and users used to ask about statistical datas that are stored in many SGBDR. It would be of great benefits for me to have all those Datas logicaly stored in one place.
Thanks in advance
Martial Elisée Wendbé KIBA
Ingénieur de Conception en Informatique
876, Avenue du Burkina secteur N°04
01 BP 1132 Ouaga 01
BURKINA FASO
Email: mkiba@delgi.gov.bf
Bureau: (+226) 50 32 62 06
Cel: (+226) 70 15 44 93
I have some questions about postgreSQL, concerning Distributed DataBases.
I know Oracle can do this very Well. With Oracle, i can configure my dataBases to use data stored in another DataSource (Microsoft SQL Server, Access, Access, ...), using Oracle Transparent Gateway.
What i want to know is There is a way to configure PostgreSQL to do the same, or there is contrib/module that i can configure to do the same like Oracle Transparent Gateway.
It is important for me because in my company, there is many DataBases Stored in different SGBDR, and users used to ask about statistical datas that are stored in many SGBDR. It would be of great benefits for me to have all those Datas logicaly stored in one place.
Thanks in advance
Ingénieur de Conception en Informatique
876, Avenue du Burkina secteur N°04
01 BP 1132 Ouaga 01
BURKINA FASO
Email: mkiba@delgi.gov.bf
Bureau: (+226) 50 32 62 06
Cel: (+226) 70 15 44 93
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
On 10/14/07, Martial Elisée Wendbé KIBA <mkiba01@yahoo.fr> wrote: > I have some questions about postgreSQL, concerning Distributed DataBases. > I know Oracle can do this very Well. With Oracle, i can configure my > dataBases to use data stored in another DataSource (Microsoft SQL Server, > Access, Access, ...), using Oracle Transparent Gateway. > What i want to know is There is a way to configure PostgreSQL to do the > same, or there is contrib/module that i can configure to do the same like > Oracle Transparent Gateway. See the projects: dblink (Postgres-to-Postgres in contrib) dblink_odbc (Postgres-to-ODBC on PgFoundry) dblink_tds (Postgres-to-Sybase/SQL Server on PgFoundry [has a memory leak]) dbi-link (Postgres-to-DBD in Perl) -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com Edison, NJ 08837 | http://www.enterprisedb.com/
Thanks for your Your Help. I'll take a look at pg_foundry and test that Martial E. W. KIBA Ingénieur de Conception en Informatiques Option Génie-Logiciel Tél: (+226) 70 15 44 93 Mail: mkiba@delgi.gov.bf / mkiba01@yahoo.fr