PGConf.Brasil - Data integration layer solution, por Gilberto Castillo
Channel: Timbira
Date: 30/09/2019

In ETECSA for different reasons emerged diverse computer solutions to respond to specific needs, both provincial and national level, all with different languages and database managers.
In ETECSA for different reasons emerged diverse computer solutions to respond to specific needs, both provincial and national level, all with different languages and database managers. Its integration over time has become increasingly difficult and in all these years many attempts have not yielded the expected results.

Through a practical use of FDW with different data sources (pdf, text, access, Ldap, mongodb, Sqlserve, Oracle, PostgreSQL, etc.), Jsonb, With recusive, Function Trigger, Upset and other to obtain the Integrated Databases of business information. The Data Integration Layer Solution achieved the planned objectives and explored previously unacknowledged issues. Where different solutions between them one implemented in Oracle by problems of operations conducive the development of this solution Based on PostgreSQL.

In use for more then 4 years.

Slides: https://wiki.postgresql.org/images/4/47/Pgconfbr-2k18-dataintegration.pdf