Distributed DataBases

Distributed DataBases

am 14.10.2007 22:53:47 von mkiba01

--0-1746488535-1192395227=:93219
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi all, I have some questions about postgreSQL, concerning Distributed=
DataBases.=0AI know Oracle can do this very Well. With Oracle, i can confi=
gure my dataBases to use data stored in another DataSource (Microsoft SQL S=
erver, Access, Access, ...), using Oracle Transparent Gateway.=0AWhat i w=
ant to know is There is a way to configure PostgreSQL to do the same, or th=
ere is contrib/module that i can configure to do the same like Oracle Trans=
parent Gateway. It is important for me because in my company, there is=
many DataBases Stored in different SGBDR, and users used to ask about stat=
istical 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 =0AMartial Elis=E9e Wendb=E9 KIBA=0AIng=E9nieur de Conceptio=
n en Informatique=0A 876, Avenue du Burkina secteur N°04=0A01 BP 1132 Oua=
ga 01=0ABURKINA FASO=0AEmail: mkiba@delgi.gov.bf=0ABureau: (+226) 50 32 6=
2 06=0ACel: (+226) 70 15 44 93 _____________=
____________________________________________________________ ____ =0ANe gard=
ez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
--0-1746488535-1192395227=:93219
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

ad>

font-size:12pt">Hi all,

I have some questions about postgreSQL, conc=
erning Distributed DataBases.
I know Oracle can do this very Well. With =
Oracle, i can configure my dataBases to use data stored in another DataSour=
ce (Microsoft SQL Server, Access,  Access, ...),  using Oracle Tr=
ansparent Gateway.
What i want to know is There is a way to configure Po=
stgreSQL 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 sto=
red in one place.

Thanks in advance

 
style=3D"font-weight: bold; color: rgb(0, 0, 127);">Martial Elis=E9e Wendb=
=E9 KIBA
le: italic; color: rgb(0, 0, 127);">Ing=E9nieur de Conception en Informatiq=
ue

 876, Avenue d=
u Burkina secteur N°04

an style=3D"color: rgb(139, 139, 139);">01 BP 1132 Ouaga 01
=3D"color: rgb(139, 139, 139);">=
BURKINA FASO

color: rgb(139, 139, 139);">Email: mkiba@delgi.gov.bf
lor: rgb(139, 139, 139);">Bureau=
:   (+226) 50 32 62 06
139);">
Cel: &nbs=
p;       (+226) 70 15 44 93


iv>


=0ANe gardez plus qu'une seu=
le adresse mail ! Copiez vo=
s mails
vers Yahoo! Mail
--0-1746488535-1192395227=:93219--

Re: Distributed DataBases

am 15.10.2007 17:42:40 von jonah.harris

On 10/14/07, Martial Elis=E9e Wendb=E9 KIBA 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)

--=20
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/

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: Distributed DataBases

am 16.10.2007 21:57:07 von Martial Elise KIBA

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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings