-1

Is there any extension/tool/script available to import data from eXist database to PostgreSQL database automatically?

Joe Wicentowski
  • 5,159
  • 16
  • 26
Jusle
  • 3
  • 2

1 Answers1

2

From the tag description it's pretty clear that you're going to need to use an ETL tool or some custom code. Which is easier depends on the nature of the data and how you want to migrate it.

I'd start by looking at Talend Studio and Pentaho Kettle. See if either of them can meet your needs.

If you can turn the eXist data into structured CSV exports then you can probably just hand-define tables for it in PostgreSQL then COPY the data into it or use pgloader.

If not, then I'd suggest picking up the language you're most familiar with (Python, Java, whatever) and using the eXist data connector for that language along with the PostgreSQL data connector for the language. Write a script that fetches data from eXist and feeds it to PostgreSQL. If using Python I'd use the Psycopg2 database connector, as it's fast and supports COPY for bulk data loading.

Craig Ringer
  • 307,061
  • 76
  • 688
  • 778
  • You can also try CloverETL. I've found it simpler to use (especially for ETL beginners) compared to Talend and Kettle. – Tomas Greif Jul 11 '13 at 07:17
  • Thank you so much. I am now doing research between these three. If the rules of stackoverflow do permit, I am happy to receive more suggestions to this thread. – Jusle Jul 11 '13 at 11:59
  • @user2569149 Sure, and folks can still post answers even after you accept one too; someone might come along with better suggestions than me after all. – Craig Ringer Jul 11 '13 at 14:05
  • @CraigRinger how to import large json data in postgresql database? thanks in advance.!!! – kiran_ray Apr 02 '21 at 06:45
  • @kiran.ray Post a new question please. – Craig Ringer Apr 05 '21 at 08:01