cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tom_Slosse
Memorable Member
Memorable Member

SQL Linked server on premise setup

Hey all,

 

I've been trying to look for a way to connect to a linked Oracle db in SQL but I can't find any way to connect with linked servers.

Why I don't wanna connect directly on the Oracle db is to prevent latceny and extra loadtimes on the db because the whole company need the db to work. So thats why we made a linked server.

 

Is there any solution to connect to a linked server in SQL?

 

Kind regards

 

 

Tom



If this reply has answered your question or solved your issue, please mark this question as answered.

Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

2 ACCEPTED SOLUTIONS

Accepted Solutions
JRaasumaa
Memorable Member
Memorable Member


@Tom_Slossewrote:

Hey all,

 

I've been trying to look for a way to connect to a linked Oracle db in SQL but I can't find any way to connect with linked servers.

Why I don't wanna connect directly on the Oracle db is to prevent latceny and extra loadtimes on the db because the whole company need the db to work. So thats why we made a linked server.

 

Is there any solution to connect to a linked server in SQL?

 

Kind regards

 

 

Tom


I don't think you'll get a great answer here for SQL related issues as PowerApps is a whole different product but the short answer is yes, if you have an Oracle account that can login to the DB you can use the SQL OLE DB Provider to create a linked server connection that should allow you to query right in SQL to the Oracle DB linked.

 

I simply googled "sql linked oracle server" and found a few immediate step by step answers on how to setup the linked server but I would proceed with caution if you aren't familiar with how to make changes to your SQL configuration.

View solution in original post

Hey @JRaasumaa,

 

 

Well I use a data gateway to PowerApps to connect to the linked server so, it is kinda a problem for PowerApps.

 

Also what I didn't think of is that you can make connection to views now with the SQL connector so I solved my problem doing just that.

 

Thanks for the information.

 

Kind regards

 

 

Tom



If this reply has answered your question or solved your issue, please mark this question as answered.

Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

View solution in original post

2 REPLIES 2
JRaasumaa
Memorable Member
Memorable Member


@Tom_Slossewrote:

Hey all,

 

I've been trying to look for a way to connect to a linked Oracle db in SQL but I can't find any way to connect with linked servers.

Why I don't wanna connect directly on the Oracle db is to prevent latceny and extra loadtimes on the db because the whole company need the db to work. So thats why we made a linked server.

 

Is there any solution to connect to a linked server in SQL?

 

Kind regards

 

 

Tom


I don't think you'll get a great answer here for SQL related issues as PowerApps is a whole different product but the short answer is yes, if you have an Oracle account that can login to the DB you can use the SQL OLE DB Provider to create a linked server connection that should allow you to query right in SQL to the Oracle DB linked.

 

I simply googled "sql linked oracle server" and found a few immediate step by step answers on how to setup the linked server but I would proceed with caution if you aren't familiar with how to make changes to your SQL configuration.

View solution in original post

Hey @JRaasumaa,

 

 

Well I use a data gateway to PowerApps to connect to the linked server so, it is kinda a problem for PowerApps.

 

Also what I didn't think of is that you can make connection to views now with the SQL connector so I solved my problem doing just that.

 

Thanks for the information.

 

Kind regards

 

 

Tom



If this reply has answered your question or solved your issue, please mark this question as answered.

Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (2,436)