{"id":109155,"date":"2017-03-01T10:43:14","date_gmt":"2017-03-01T18:43:14","guid":{"rendered":""},"modified":"2025-06-11T08:15:34","modified_gmt":"2025-06-11T15:15:34","slug":"connecting-to-oracle-database-from-powerapps-flow-and-logic-apps","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/","title":{"rendered":"Connecting to Oracle Database from PowerApps, Flow and Logic Apps"},"content":{"rendered":"<p>You can now connect to your Oracle Database from PowerApps, Flow and Logic Apps.\u00a0 The Oracle Database connection allows you to list tables, and perform standard create, read, update and delete of rows in an Oracle databases.\u00a0 In addition, it supports full <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/delegation-overview\/\">delegation of PowerApps\u2019 filtering, sorting and other functions<\/a>.\u00a0 It does not support triggers or store procedures yet.<\/p>\n<p><strong>Supported versions<\/strong>: Oracle 9 and later, Oracle client software 8.1.7 and later.<\/p>\n<h2>Pre-requisites<\/h2>\n<p>The Oracle Database connection requires the installation of the on-premises data gateway and Oracle client SDK.<\/p>\n<h3>Install On-premises Data\u00a0Gateway<\/h3>\n<p>The Oracle Database connection requires the On-premises data gateway to be installed.\u00a0 Based on the service that you want to connect to, you can follow the steps defined below to install:<\/p>\n<ul>\n<li>Flow: <a href=\"https:\/\/ms.flow.microsoft.com\/en-us\/documentation\/gateway-manage\/\">https:\/\/ms.flow.microsoft.com\/en-us\/documentation\/gateway-manage\/<\/a><\/li>\n<li>PowerApps: <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/gateway-management\/\">https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/gateway-management\/<\/a><\/li>\n<li>Logic Apps: <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/logic-apps\/logic-apps-gateway-connection\">https:\/\/docs.microsoft.com\/en-us\/azure\/logic-apps\/logic-apps-gateway-connection<\/a><\/li>\n<\/ul>\n<p><strong>A note about the on-premises data gateway<\/strong>:\u00a0 The on-premises data gateway acts as a bridge, providing quick and secure data transfer between on-premises data (data that is not in the cloud) and the Power BI, Microsoft Flow, Logic Apps, and PowerApps services.\u00a0 The same gateway can be used with multiple services and multiple data sources.\u00a0 So, you will probably need to do this only once.\u00a0 More about gateways can be found here (<a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/gateway-reference\/\">https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/gateway-reference\/<\/a>).<\/p>\n<h3>Install Oracle Client<\/h3>\n<p>To connect to Oracle, you will also need to install the Oracle client software on the machine where you have installed the on-premises data gateway.\u00a0 Specifically, the Oracle Database connection requires the installation of the 64-bit Oracle Data Provider for .NET.\u00a0 You can use the following link to download and install the Oracle client:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.oracle.com\/technetwork\/database\/windows\/downloads\/index-090165.html\">64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64<\/a><\/li>\n<\/ul>\n<p>If you do not have the Oracle client installed, you will see an error when you try to create or use the connection (see the known issues below).<\/p>\n<h2>Create an app using Oracle Database connection<\/h2>\n<p>Depending on the service you are using, follow the appropriate steps to create a connection.\u00a0 Here, we will use PowerApps, but the steps for <a href=\"https:\/\/ms.flow.microsoft.com\/en-us\/documentation\/add-manage-connections\/\">Flow<\/a> and <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/logic-apps\/logic-apps-create-a-logic-app\">Logic Apps<\/a> should be similar.\u00a0 Even with PowerApps, there are multiple ways in which you can start using the connection.\u00a0 In this walkthrough, we will use the PowerApps\u2019s feature of creating an app from an Oracle database table.<\/p>\n<p>Follow the steps below to create an app from an Oracle database in PowerApps:<\/p>\n<ol>\n<li>Open PowerApps Studio, sign in if it prompts you to, and click New to create a new app.<br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"135\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/0020fd1d-1e13-4202-97a4-cf90527b75a4.png\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" title=\"image\" width=\"151\"\/><\/li>\n<li>Under \u201cStart with your data\u201d, click on the arrow which will show you a list of connections you already have.\u00a0 Click on \u201c+New connection\u201d to specify that you want to create a new connection.<br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"91\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/e89fc037-69b6-44c0-bf35-1039430af7b0.png\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" title=\"image\" width=\"356\"\/><\/li>\n<li>Under the list of connections, select \u201cOracle Database\u201d.<br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"67\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/7d1a67b4-1c68-49ee-84c2-f0b0383c9a9a.png\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" title=\"image\" width=\"341\"\/><\/li>\n<li>On the right side, specify the Oracle server name, username and password.\u00a0 For the server, if an SID is required, you can specify this in the format: ServerName\/SID.<br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"279\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/f4966aed-0e49-4e30-b41f-2cbe1c7e37c1.png\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" title=\"image\" width=\"427\"\/><\/li>\n<li>As mentioned above, you will need to use a Gateway to use an Oracle Database connection.\u00a0 Select the appropriate gateway.\u00a0 If required, you can also install a gateway.\u00a0 Click on \u201cRefresh gateway list\u201d if you do not see your gateway.<br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"163\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/0a718402-d85e-4788-a65d-1f7e90ba1f53.png\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" title=\"image\" width=\"548\"\/><\/li>\n<li>Click \u201cCreate\u201d to create the connection.\u00a0 If everything is fine, you will see the screen to select a dataset with a single dataset called \u201cdefault\u201d.<br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"54\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/b71f98f5-52e2-4bbe-a0fd-e42215ca4d30.png\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; margin: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" title=\"image\" width=\"149\"\/><\/li>\n<li>Select default.<br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"101\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/68cc261f-a241-432d-a1d0-b49042865f11.png\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" title=\"image\" width=\"310\"\/><\/li>\n<li>You will see a list of tables based on the Oracle database you are connecting to.\u00a0 Select the table that you want to use.<br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"346\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/8d2176ed-157b-4128-88a4-5b7f4740932e.png\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" title=\"image\" width=\"421\"\/><\/li>\n<li>Click \u201cConnect\u201d to create the app<br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"53\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/fb247914-fab5-4ff1-8605-656a118c3660.png\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" title=\"image\" width=\"156\"\/><\/li>\n<\/ol>\n<p>Based on the table that you selected, PowerApps will create an app for you with three screens:<\/p>\n<ul>\n<li>A Browse screen that list all the entries in the table<\/li>\n<li>A Detail screen that provides additional info about an entry<\/li>\n<li>An Edit screen that can be used for updating an existing entry or creating a new entry<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"PowerApps Oracle screens\" border=\"0\" height=\"312\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/164c4baf-ceae-4889-a4dc-8229087fab2d.png\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" title=\"PowerApps Oracle screens\" width=\"542\"\/><\/p>\n<p>This is just the starting point.\u00a0 You may want to customize these screens, add more tables into your app to finish up your app.\u00a0 You can refer to <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/getting-started\/\">PowerApps documentation<\/a> for more information.<\/p>\n<h2>Creating a flow using the Oracle Database connection<\/h2>\n<p>You can use the steps for <a href=\"https:\/\/ms.flow.microsoft.com\/en-us\/documentation\/add-manage-connections\/\">Flow<\/a> and <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/logic-apps\/logic-apps-create-a-logic-app\">Logic Apps<\/a> to create a flow or a logic app and use the Oracle Database connection.\u00a0 I will not go into the details here, but the steps for creating the connection should be very similar to the steps listed above.\u00a0 The Oracle Database connection does not yet support any triggers.\u00a0 So, use another trigger at the start of your workflow. In a logic app, for example, you can use the Request\/Response trigger to start your logic app, and then add the Oracle Database connection to see its actions.\u00a0 Once you have a connection, you can use any of the actions listed below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"Flow Oracle Database actions\" border=\"0\" height=\"364\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/c479e96f-9510-40e4-bd89-fccf0572a0da.png\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" title=\"Flow Oracle Database actions\" width=\"298\"\/><\/p>\n<h2>Known Issues, Tips, and Troubleshooting<\/h2>\n<p>Here are some common issues, limitations and workarounds:<\/p>\n<ol>\n<li>Cannot reach the Gateway.<br \/>\n\tIf you get this error \u201cCannot reach the Gateway\u201d, it means that on-premises data gateway is not able to connect to the cloud.\u00a0 To check the status of your Gateway, you can login to powerapps.microsoft.com.\u00a0 Click Gateways, and select\/click the Gateway you are trying to connect to.<br \/>\n<strong>Mitigation<\/strong>: Make sure your gateway is running on the on-premise machine where it is installed, and that it can connect to the internet.\u00a0 We recommend against installing the gateway on a computer that may be turned off or sleep.\u00a0 Try restarting the on-premises data gateway service (PBIEgwService) as well.<\/li>\n<li>The provider being used is deprecated: &#8216;System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.&#8217;. Please visit <a href=\"https:\/\/go.microsoft.com\/fwlink\/p\/?LinkID=272376\">https:\/\/go.microsoft.com\/fwlink\/p\/?LinkID=272376<\/a> to install the official provider.<br \/>\n\tYou get the above error if the Oracle client SDK is not installed on the machine where the on-premises data gateway is running.\u00a0 To fix this issue, download and install the Oracle client SDK as given above.<\/li>\n<li>Table &#8216;[Tablename]&#8217; does not define any key columns<br \/>\n\tThis error message signifies that the table it is connecting to, does not have any primary key.\u00a0 Currently, the Oracle Database connection requires that a table with a primary key column be used.<\/li>\n<li>Stored Procedures are currently not supported.\u00a0 We are looking at adding this functionality in the future.\u00a0 We would like you to vote for it in the community forum if you are interested.<\/li>\n<li>Any table with composite keys are not supported.\u00a0 We would like you to vote for it in the community forum if you are interested.<\/li>\n<li>Nested object types in tables are not supported.\u00a0 We would like you to vote for it in the community forum if you are interested.<\/li>\n<\/ol>\n<p>The Oracle Database connection is one of the connectors that many of our users have asked for.\u00a0 We hope to get some usage and feedback on this.\u00a0 Please feel free to use the <a href=\"https:\/\/powerusers.microsoft.com\/t5\/PowerApps-Community\/ct-p\/PowerApps1\">community forums<\/a> to provide us your bug reports, feedback and ideas.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can now connect to your Oracle Database from PowerApps, Flow and Logic Apps.<\/p>\n","protected":false},"author":149,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","ms-ems-related-posts":[],"footnotes":""},"audience":[3378],"content-type":[3424,3423],"job-role":[],"product":[3473],"property":[],"topic":[3421],"coauthors":[2351],"class_list":["post-109155","post","type-post","status-publish","format-standard","hentry","audience-it-professional","content-type-news","content-type-tips-and-guides","product-power-apps","topic-application-modernization"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Connecting to Oracle Database from PowerApps, Flow and Logic Apps - Microsoft Power Platform Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connecting to Oracle Database from PowerApps, Flow and Logic Apps - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"You can now connect to your Oracle Database from PowerApps, Flow and Logic Apps.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-03-01T18:43:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:15:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/0020fd1d-1e13-4202-97a4-cf90527b75a4.png\" \/>\n<meta name=\"author\" content=\"Sameer Chabungbam\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sameer Chabungbam\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/sameer-chabungbam\/\",\"@type\":\"Person\",\"@name\":\"Sameer Chabungbam\"}],\"headline\":\"Connecting to Oracle Database from PowerApps, Flow and Logic Apps\",\"datePublished\":\"2017-03-01T18:43:14+00:00\",\"dateModified\":\"2025-06-11T15:15:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/\"},\"wordCount\":1156,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/0020fd1d-1e13-4202-97a4-cf90527b75a4.png\",\"keywords\":[\"Connectors\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/\",\"name\":\"Connecting to Oracle Database from PowerApps, Flow and Logic Apps - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/0020fd1d-1e13-4202-97a4-cf90527b75a4.png\",\"datePublished\":\"2017-03-01T18:43:14+00:00\",\"dateModified\":\"2025-06-11T15:15:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/#primaryimage\",\"url\":\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/0020fd1d-1e13-4202-97a4-cf90527b75a4.png\",\"contentUrl\":\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/0020fd1d-1e13-4202-97a4-cf90527b75a4.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Connecting to Oracle Database from PowerApps, Flow and Logic Apps\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/person\/7e65be8afd5ab2e917ffb00bf86fa851\",\"name\":\"Sameer Chabungbam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/82b849554b986091c24672ac9e11a25786b4906721bd255d71c66ca68fdd5dfd?s=96&d=mm&r=g8b3ea029f47fbfb348e520d00a165495\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/82b849554b986091c24672ac9e11a25786b4906721bd255d71c66ca68fdd5dfd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/82b849554b986091c24672ac9e11a25786b4906721bd255d71c66ca68fdd5dfd?s=96&d=mm&r=g\",\"caption\":\"Sameer Chabungbam\"},\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/sameerch\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Connecting to Oracle Database from PowerApps, Flow and Logic Apps - Microsoft Power Platform Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/","og_locale":"en_US","og_type":"article","og_title":"Connecting to Oracle Database from PowerApps, Flow and Logic Apps - Microsoft Power Platform Blog","og_description":"You can now connect to your Oracle Database from PowerApps, Flow and Logic Apps.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2017-03-01T18:43:14+00:00","article_modified_time":"2025-06-11T15:15:34+00:00","og_image":[{"url":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/0020fd1d-1e13-4202-97a4-cf90527b75a4.png","type":"","width":"","height":""}],"author":"Sameer Chabungbam","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sameer Chabungbam","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/sameer-chabungbam\/","@type":"Person","@name":"Sameer Chabungbam"}],"headline":"Connecting to Oracle Database from PowerApps, Flow and Logic Apps","datePublished":"2017-03-01T18:43:14+00:00","dateModified":"2025-06-11T15:15:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/"},"wordCount":1156,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/#primaryimage"},"thumbnailUrl":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/0020fd1d-1e13-4202-97a4-cf90527b75a4.png","keywords":["Connectors"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/","name":"Connecting to Oracle Database from PowerApps, Flow and Logic Apps - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/#primaryimage"},"thumbnailUrl":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/0020fd1d-1e13-4202-97a4-cf90527b75a4.png","datePublished":"2017-03-01T18:43:14+00:00","dateModified":"2025-06-11T15:15:34+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/#primaryimage","url":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/0020fd1d-1e13-4202-97a4-cf90527b75a4.png","contentUrl":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/0020fd1d-1e13-4202-97a4-cf90527b75a4.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2017\/03\/01\/connecting-to-oracle-database-from-powerapps-flow-and-logic-apps\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Connecting to Oracle Database from PowerApps, Flow and Logic Apps"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/person\/7e65be8afd5ab2e917ffb00bf86fa851","name":"Sameer Chabungbam","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/82b849554b986091c24672ac9e11a25786b4906721bd255d71c66ca68fdd5dfd?s=96&d=mm&r=g8b3ea029f47fbfb348e520d00a165495","url":"https:\/\/secure.gravatar.com\/avatar\/82b849554b986091c24672ac9e11a25786b4906721bd255d71c66ca68fdd5dfd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/82b849554b986091c24672ac9e11a25786b4906721bd255d71c66ca68fdd5dfd?s=96&d=mm&r=g","caption":"Sameer Chabungbam"},"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/sameerch\/"}]}},"bloginabox_animated_featured_image":null,"bloginabox_display_generated_audio":false,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/109155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/149"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=109155"}],"version-history":[{"count":2,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/109155\/revisions"}],"predecessor-version":[{"id":131334,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/109155\/revisions\/131334"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=109155"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=109155"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=109155"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=109155"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=109155"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=109155"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=109155"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=109155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}