Question & Answer > View Question

Connect external database

Confluence User - 14 Mar, 2016

I want to connect external db between Joget and Odoo ERP (PostgreSQL DB). I have 2 way for connect.

create own web service and use JSON plugin to connect that service. Can json plugin do that ?
use bean shell to create connection to external DB.

Please explain pros. and cons of both method and which method do you recommend?

If you have documentation about this please send to me

database

1

Confluence User •

15 Mar, 2016 •

confluenceUser •

•

confluenceUser •

create own web service and use JSON plugin to connect that service. Can json plugin do that ?

This is a very good idea. To only consume what is enlisted.

use bean shell to create connection to external DB.

Exposing and writing directly into another system's database is risky as the other system may not be aware of the kind of data manipulation made. the web service way you mentioned is better.

See Integration

1

CSV | Excel | XML | PDF

Your answer

Print

Connect external database

1

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

Connect external database.builder-style-609fadaa-6315-4d45-8338-13f9a28cf2f3{background: #efefef59 !important; margin: 0px !important; padding: 10px !important; border-radius: 5px !important; border: 1px solid #ddd !important; text-align: left !important; color:#0E4A40 !important;}

1.builder-style-844121db-e7b2-42ef-b9b9-f2459007ec1a{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-d58080a7-effe-4ee1-aaeb-e6532ba7b3e6{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

Connect external database

1

Your answer