appsmith icon indicating copy to clipboard operation
appsmith copied to clipboard

[Feature]: Integration with database Oracle

Open gabriel210467 opened this issue 4 years ago • 23 comments

Is there an existing issue for this?

  • [X] I have searched the existing issues

Summary

I didn’t find Oracle database support in the built in integration

Why should this be worked on?

We thought it should be standard database used by many corporation as of MS SQL Server

gabriel210467 avatar Jan 01 '22 09:01 gabriel210467

I would like to reinforce that Oracle database support is essential to my company as many others

guidogabriel avatar Jan 14 '22 11:01 guidogabriel

Thanks for the upvote @guidogabriel!

Nikhil-Nandagopal avatar Jan 14 '22 11:01 Nikhil-Nandagopal

Important for us too as without Oracle Database support we can even move past the POC stage

ag-anshul avatar Feb 06 '22 13:02 ag-anshul

Unfortunately I will have to use budibase until appsmith can integrate with oracle. I can do nothing without it

guidogabriel avatar Feb 11 '22 16:02 guidogabriel

@guidogabriel sorry about that! We haven't been able to prioritize this yet. We'll do our best to try and pick this up soon

Nikhil-Nandagopal avatar Feb 16 '22 13:02 Nikhil-Nandagopal

Unfortunately I will have to use budibase until appsmith can integrate with oracle. I can do nothing without it

I am curious - how are you using budibase if it doesn't have a native Oracle connection?

frankremedy avatar Mar 22 '22 12:03 frankremedy

I will upvote as well for this feature. I am wanting to go down the Appsmith route but as we don't have true developers other than myself, working on FDW or API is cumbersome and have to be contracted out. I have thought about moving to Retool but don't want to spend on a toolset when we are trying to get adoption.

frankremedy avatar Mar 22 '22 12:03 frankremedy

I am curious - how are you using budibase if it doesn't have a native Oracle connection?

@frankremedy maybe the oracle integration isnt in the oficial budibase's documentation but it is already have native oracle integration. If you install budibase, you will see it.

There is a mention to that in the inicial page: https://budibase.com/ and there is a topic confirming it https://github.com/Budibase/budibase/discussions/2285

guidogabriel avatar Mar 27 '22 19:03 guidogabriel

Hi, For us is also very important to have the oracle integration. Thanks

zon7 avatar Mar 31 '22 16:03 zon7

I am happy to also pay for this type of integration with Enterprise Edition

frankremedy avatar Mar 31 '22 16:03 frankremedy

While appsmith doesn't have native integration with oracle, i'm using an oracle service called ORDS (oracle rest data service). I think it's worth do a little search about it

guidogabriel avatar Apr 10 '22 21:04 guidogabriel

@rohan-arthur Can we prioritise this integration? Oracle is one of the most widely used databases.

danciaclara avatar Aug 08 '22 13:08 danciaclara

@rohan-arthur Can we prioritise this integration? Oracle is one of the most widely used databases.

agreed as mentioned I would be happy to have this part of Enterprise :)

frankremedy avatar Aug 08 '22 14:08 frankremedy

I agree with all the posters, I'm evaluating using appsmith in our Org , without Oracle database support its a significant hurdle to adopting the tool as a low-code solution as we have 1000+ Oracle databases .

mgperry1 avatar Aug 31 '22 17:08 mgperry1

Options with this limit - FDW (gross) or use the Oracle API But bottom line, we would rather connect natively

Frank Derenne IT Administrator and Security Officer @.*** Office 800-975-9517 Ext.737 Remedy Analytics, Inc. 234 W. Florida Street, Suite 150 Milwaukee, WI 53204 remedyanalytics.com ​

The information contained in this communication, including attachments, is confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately. Thank you.

From: Matt Perry @.> Sent: Wednesday, August 31, 2022 12:42 PM To: appsmithorg/appsmith @.> Cc: Frank Derenne @.>; Mention @.> Subject: Re: [appsmithorg/appsmith] [Feature]: Integration with database Oracle (Issue #10096)

[External]

I agree with all the posters, I'm evaluating using appsmith in our Org , without Oracle database support its a significant hurdle to adopting the tool as a low-code solution as we have 1000+ Oracle databases .

Reply to this email directly, view it on GitHubhttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fappsmithorg%2Fappsmith%2Fissues%2F10096%23issuecomment-1233232192&data=05%7C01%7Cfrank.derenne%40remedyanalytics.com%7C2001636d6cea48e1e08608da8b781b39%7Cf1289cc584564f288eab700d1300fc5d%7C0%7C0%7C637975645210952057%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=AWiFR34CKhP3bsNLGvgJTKNPuRrr8PAHcBEuyQ%2BjFdI%3D&reserved=0, or unsubscribehttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FALVQ5NLIZEOG2VBBJ7UIZ4LV36KONANCNFSM5LCJLSEQ&data=05%7C01%7Cfrank.derenne%40remedyanalytics.com%7C2001636d6cea48e1e08608da8b781b39%7Cf1289cc584564f288eab700d1300fc5d%7C0%7C0%7C637975645210952057%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=N5UYxViZT8G5W4j0Snppehz4jdycdFl82NVBw4RLBwc%3D&reserved=0. You are receiving this because you were mentioned.Message ID: @.@.>>

frankremedy avatar Aug 31 '22 17:08 frankremedy

I tried using + Oracle rest data service (ORDS) and it wasn't productive (brings an additional layer of complexity totally unnecessary). As long as appsmith doesn't have native integration with the oracle database, it won't be possible to use it here in my organization

guidogabriel avatar Sep 08 '22 18:09 guidogabriel

Yeah Understand that in regards to the ORDS. Same with using an FDW. It has hindered our use of Appsmith for further application development to the point we are looking at other toolsets. We do use Apex but we want to move to platforms where the database won't matter.

Frank Derenne IT Administrator and Security Officer @.*** Office 800-975-9517 Ext.737 Remedy Analytics, Inc. 234 W. Florida Street, Suite 150 Milwaukee, WI 53204 remedyanalytics.com ​

The information contained in this communication, including attachments, is confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately. Thank you.

From: guidogabriel @.> Sent: Thursday, September 8, 2022 1:02 PM To: appsmithorg/appsmith @.> Cc: Frank Derenne @.>; Mention @.> Subject: Re: [appsmithorg/appsmith] [Feature]: Integration with database Oracle (Issue #10096)

[External]

I tried using + Oracle rest data service (ORDS) and it wasn't productive (brings an additional layer of complexity totally unnecessary). As long as appsmith doesn't have native integration with the oracle database, it won't be possible to use it here in my organization

Reply to this email directly, view it on GitHubhttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fappsmithorg%2Fappsmith%2Fissues%2F10096%23issuecomment-1241052301&data=05%7C01%7Cfrank.derenne%40remedyanalytics.com%7Cf666109508ac45c0ecd508da91c436a4%7Cf1289cc584564f288eab700d1300fc5d%7C0%7C0%7C637982569166070291%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=7tPASzlHPOVLFLEDSWjjCvfp5IwA2T17lAGZ7rjFYEI%3D&reserved=0, or unsubscribehttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FALVQ5NMIYWN4EW6XDF2HLZ3V5ISZDANCNFSM5LCJLSEQ&data=05%7C01%7Cfrank.derenne%40remedyanalytics.com%7Cf666109508ac45c0ecd508da91c436a4%7Cf1289cc584564f288eab700d1300fc5d%7C0%7C0%7C637982569166070291%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=dRS8jIooKBC%2BYBoixhOG56Ta1av4BNXV7rWQD7XIzkg%3D&reserved=0. You are receiving this because you were mentioned.Message ID: @.@.>>

frankremedy avatar Sep 09 '22 12:09 frankremedy

Some news about PR?

guidogabriel avatar Oct 07 '22 01:10 guidogabriel

@guidogabriel apologies, we are facing an acute shortage of bandwidth at the moment. It might take at least a few more weeks before we can get this feature out.

sumitsum avatar Oct 07 '22 04:10 sumitsum

+1 also needed by our customer

practical-programmer avatar Nov 29 '22 08:11 practical-programmer

Guess that i m every week visting this thread LoL

guidogabriel avatar Dec 01 '22 21:12 guidogabriel

@guidogabriel we appreciate your patience with us 😄 We're finally prioritising this in Jan. Stay tuned for updates!

Nikhil-Nandagopal avatar Dec 10 '22 07:12 Nikhil-Nandagopal

upvote for oracle support.

g05357005 avatar Dec 24 '22 07:12 g05357005

@guidogabriel we appreciate your patience with us 😄 We're finally prioritising this in Jan. Stay tuned for updates!

Im still tuned 😄

guidogabriel avatar Jan 25 '23 12:01 guidogabriel

Waiting as well :)

Frank Derenne IT Administrator and Security Officer @.*** Office 800-975-9517 Ext.737 Remedy Analytics, Inc. 234 W. Florida Street, Suite 150 Milwaukee, WI 53204 remedyanalytics.com ​

Privacy Notice | ​Legal Notice

CONFIDENTIALITY NOTICE: The information contained in this communication, including attachments, may contain privileged and confidential information that is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us by telephone immediately.

Please be advised that any and all information, comments, analysis, and/or recommendations set forth above relative to the possible impact of COVID-19 on potential insurance coverage or other policy implications are intended solely for informational purposes and should not be relied upon as legal advice. We have no authority to make coverage decisions as that ability rests solely with the issuing carrier. Therefore, all claims should be submitted to the carrier for evaluation. The positions expressed herein are opinions only and are not to be construed as any form of guarantee or warrantee. Finally, given the extremely dynamic and rapidly evolving COVID-19 situation, comments above do not take into account any applicable pending or future legislation introduced with the intent to override, alter or amend current policy language.


From: guidogabriel @.> Sent: Wednesday, January 25, 2023 6:18:59 AM To: appsmithorg/appsmith @.> Cc: Frank Derenne @.>; Mention @.> Subject: Re: [appsmithorg/appsmith] [Feature]: Integration with database Oracle (Issue #10096)

[External]

@guidogabrielhttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fguidogabriel&data=05%7C01%7Cfrank.derenne%40remedyanalytics.com%7C2e5775a88dee4ec376e208dafece5732%7Cf1289cc584564f288eab700d1300fc5d%7C0%7C0%7C638102459455414864%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Hi6RmzI9tu2Sg4yxebi5diY%2FVeRCo6IQXd7ZkL9xhNM%3D&reserved=0 we appreciate your patience with us 😄 We're finally prioritising this in Jan. Stay tuned for updates!

Im still tuned 😄

— Reply to this email directly, view it on GitHubhttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fappsmithorg%2Fappsmith%2Fissues%2F10096%23issuecomment-1403522380&data=05%7C01%7Cfrank.derenne%40remedyanalytics.com%7C2e5775a88dee4ec376e208dafece5732%7Cf1289cc584564f288eab700d1300fc5d%7C0%7C0%7C638102459455414864%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=wOrxFP4Ta876cyoslIAu6mvhIbPWymghPShxoolfgR4%3D&reserved=0, or unsubscribehttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FALVQ5NJPTCCRTXBC7UJWGGTWUEK3HANCNFSM5LCJLSEQ&data=05%7C01%7Cfrank.derenne%40remedyanalytics.com%7C2e5775a88dee4ec376e208dafece5732%7Cf1289cc584564f288eab700d1300fc5d%7C0%7C0%7C638102459455414864%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Y4Fp8eo6KYS81NHFB%2FrswSEgp1Z8hK%2BGCzh3H9myc0o%3D&reserved=0. You are receiving this because you were mentioned.Message ID: @.***>

frankremedy avatar Jan 25 '23 13:01 frankremedy

Yeah looked at the PR and it looked like much of the work was completed.. Oracle Data source support would really help sell the need to spend on appsmith for low/code

mgperry1 avatar Jan 25 '23 14:01 mgperry1

We had some critical issues that came up in the past two weeks. The Oracle PR is now in progress, expect updates soon!

rohan-arthur avatar Feb 02 '23 10:02 rohan-arthur

do you have an expected date for this integration?

fredhii avatar Mar 24 '23 13:03 fredhii

Its been a minute, hoping to see this feature soon....

mgperry1 avatar Mar 24 '23 19:03 mgperry1

Same. I know that it was delayed for a bit but is there an ETA to get this released?

thanks

Frank Derenne IT Administrator and Security Officer @.*** Office 800-975-9517 Ext.737 Remedy Analytics, Inc. 234 W. Florida Street, Suite 150 Milwaukee, WI 53204 remedyanalytics.com ​

Privacy Notice | ​Legal Notice

CONFIDENTIALITY NOTICE: The information contained in this communication, including attachments, may contain privileged and confidential information that is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us by telephone immediately.

Please be advised that any and all information, comments, analysis, and/or recommendations set forth above relative to the possible impact of COVID-19 on potential insurance coverage or other policy implications are intended solely for informational purposes and should not be relied upon as legal advice. We have no authority to make coverage decisions as that ability rests solely with the issuing carrier. Therefore, all claims should be submitted to the carrier for evaluation. The positions expressed herein are opinions only and are not to be construed as any form of guarantee or warrantee. Finally, given the extremely dynamic and rapidly evolving COVID-19 situation, comments above do not take into account any applicable pending or future legislation introduced with the intent to override, alter or amend current policy language.


From: Matt Perry @.> Sent: Friday, March 24, 2023 2:17 PM To: appsmithorg/appsmith @.> Cc: Frank Derenne @.>; Mention @.> Subject: Re: [appsmithorg/appsmith] [Feature]: Integration with database Oracle (Issue #10096)

[External]

Its been a minute, hoping to see this feature soon....

— Reply to this email directly, view it on GitHubhttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fappsmithorg%2Fappsmith%2Fissues%2F10096%23issuecomment-1483296094&data=05%7C01%7Cfrank.derenne%40remedyanalytics.com%7C63eddbcae9c645783fde08db2c9c72f1%7Cf1289cc584564f288eab700d1300fc5d%7C0%7C0%7C638152822689564468%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=UMHcR9jSHEeXz6iZ2G6hw7Nzx57Zj7pqLQAF9lyi%2BXo%3D&reserved=0, or unsubscribehttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FALVQ5NPO5CAQIGLQNEYV7NLW5XXNTANCNFSM5LCJLSEQ&data=05%7C01%7Cfrank.derenne%40remedyanalytics.com%7C63eddbcae9c645783fde08db2c9c72f1%7Cf1289cc584564f288eab700d1300fc5d%7C0%7C0%7C638152822689564468%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=ZiJ5xUX%2BlvyuAsJ85hKUhKCSpNiq8H0A07MtbO764G0%3D&reserved=0. You are receiving this because you were mentioned.Message ID: @.***>

frankremedy avatar Mar 27 '23 14:03 frankremedy