Post Closed
299
Views
27
Comments
Extend ODC Apps with Microsoft SQL Server and Oracle Integrations

Hello, fellow community members! 

We’re excited to announce a new release of OutSystems Developer Cloud. In this new version, we’ve made it easier to integrate with Microsoft SQL Server and Oracle databases. We abstract the way you connect to an external database, allowing you to seamlessly integrate with these data sources, through an easy-to-use setup journey, and provide a unique data representation, regardless of the data source while addressing relevant non-functional requirements, such as performance and security.

Find the necessary steps below:

  1. In ODC Portal, navigate to the Connections console, and select the database provider

  2. Fill in the database details

  3. Select the desired entities and attributes

  4. In ODC Studio, open the Add Public Elements dialog and select the entities

  5. All set!


What you should know before you start

It’s recommended to upgrade your ODC Studio to the latest version so that you can take advantage of this new integration feature. You can download it from your ODC Portal.

You can learn all about these external database integrations in ODC here.

We encourage you to try it out and give us your feedback! Please convey feedback through ODC Studio or simply by using this forum post thread. 

Cheers,
OutSystems team

2024-01-09 08-05-30
Dipali Shrawane

This is great news! But anyone knows how we can create personal environment for ODC studio? Excluding that temporary one which was allocated to us for training purpose.

2023-04-19 18-38-51
Bas de Jong

Currently not possible! 

UserImage.jpg
Narendra Maheshwari

This is great news! 

UserImage.jpg
Zubair Khan

Hello, fellow community members! 

We’re excited to announce a new release of OutSystems Developer Cloud. In this new version, we’ve made integrating with Microsoft SQL Server and Oracle databases easier. We abstract how you connect to an external database, allowing you to seamlessly integrate with these data sources through an easy-to-use setup journey, and provide a unique data representation, regardless of the data source, while addressing relevant non-functional requirements, such as performance and security.

Find the necessary steps below:

  1. In ODC Portal, navigate to the Connections console, and select the database provider

  2. Fill in the database details

  3. Select the desired entities and attributes

  4. In ODC Studio, open the Add Public Elements dialog and select the entities

  5. All set!

2014-10-21 20-15-17
Alberto Ferreira

Very Good News

2021-08-31 07-27-14
Vijay Perumalsamy

Thank you for sharing this!

2023-06-15 18-30-12
FRANK JOHNNY GANGUILHET

That“s great!!!

2022-03-09 07-24-55
BARKHA Pradhan
Thank you for sharing this!
2023-03-21 09-05-05
m.irfan.azam

Definitely a valuable addition. 

2021-03-05 13-56-11
Ricardo Pereira
Ā 
MVP

Hi,

About ODC Studio: when it will have auto-update like Service Studio to avoid the need of update manually?


Thanks!


Best regards,

Ricardo Pereira

2025-04-16 10-58-33
Priyanka Babar

Thankyou for sharing! 

2024-07-16 17-36-51
Shradha Rawlani

This is very helpful for development!!

2022-12-26 04-01-30
Anuj Kumar Chauhan

Great News!

2021-07-09 11-03-39
Roshan Nayak

Amazing work done !

2026-04-23 05-29-20
Prince Kumar

Thanks for sharing this. It's a great news!

2021-05-21 21-56-03
Anderson!

šŸ¤™

2023-03-07 09-33-07
Richard Dyson

That“s great!!! Thank you for sharing this!

2022-07-03 17-24-08
Sourabh sharma

Definitely a valuable addition. 

2023-04-29 09-42-19
Valerie Danna

Great news!

2023-04-29 09-42-19
Valerie Danna

Thank you for sharing !

2023-03-16 04-58-56
Ashish Lonkar

Nice !!

2021-12-23 04-28-09
Navneet Sharma

Awesome!!!

2022-08-10 06-17-04
Mita

Awesome!

UserImage.jpg
Anuli Hande

Thank you for sharing this !

2023-04-05 12-45-27
Dalila Angélica

Great!

2021-01-19 14-07-32
Tom Zhao

ThatĀ“s great!!! 

2024-07-05 14-16-55
Daniël Kuhlmann
Ā 
MVP

Closing this post. No meaningful replies are added. If you think it's great improvement of ODC just press the like button.