I've developed (together with two colleagues) a win32 application framework (a kind of ERP) which was named "Ouverture". It is heavily based on Oracle (stored procedure, temporary tables, view (very complex ones)).
I'll blog about this product later. For now I would like to recap my findings in the, it seems, not so explored area of "link between Postgresql and Oracle".
My company asked me to investigate the possibility of querying the Oracle tables, used by Ouverture, from a Postgresql database (pg from here on). Please note that the link should go strictly this way, not from Oracle to Pg.
I started searching the net and found, for my surprise, that there is no *built in* support in pg for linking an external database but there is a "contrib" project called dbi_link (). Knowing nothing about pg, perl and DBI I've started studying this package. First thing that I noticed was that there is very low activity about it: last available version is from year 2007 and there is very low activity on forums. I've also contacted the dbi-link author, Dave Fetter, but he doesn't seem much willing to help me .... maybe he is too busy.
See next posts (I don't like long posts :-)) to see my dbi-link experience...
See you
Wednesday, December 30, 2009
Subscribe to:
Comments (Atom)