Database connectivity

Database connectivity

  

hi,

Can i connect an external SQL database with my web application in outsystems?

      And it is need to be dynamically changing the data.that is if i connected once my web details wants to be automatically when any changes in the database.

please help

thank you

Hi Chandru,

Yes, it's possible to connect to an external database using Outsystems. You use an extension that maps the external database tables, after which you can use them as normal Outsystems tables.

You can find more information here:
https://success.outsystems.com/Documentation/10/Extensibility_and_Integration/Integrate_with_an_External_Database


Goodluck!

Lennart Kraak wrote:

Hi Chandru,

Yes, it's possible to connect to an external database using Outsystems. You use an extension that maps the external database tables, after which you can use them as normal Outsystems tables.

You can find more information here:
https://success.outsystems.com/Documentation/10/Extensibility_and_Integration/Integrate_with_an_External_Database


Goodluck!

thank you sir.

   but can we auto update the  outsystems tables when we make changes in the external database?


Hi Chandru,

The external entities mapped in integration are not NEW entities in OutSystems with data copied from the external database. It's just a transparent way for you to access the external database.

This means that if you change data in the external database and than in OutSystems fetch data from this entity, you will see your updated data.

In any case, if it is not what you meant and you really mean to update OUTSYSTEMS database based on changes in EXTERNAL database, please, see my answer in your other question.