Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What is the syntax for connection an Oracle through a Power Excel Query

User_WICXRMay 10 2021

Hello,
Can someone help me in finding the correct syntax to connect with an oracle database with an Excel Power Query?
In my SQL the syntax is something like this below :
let
ParamTable = Excel.CurrentWorkbook(){[Name="TableParam"]}[Content],
birthYear = Record.Field(ParamTable{0},"Value"),
firstName = Record.Field(ParamTable{1},"Value"),
Source = Sql.Database("HOMESERVER\KOTOR", "AdventureWorksDW"),
GoQuery = Value.NativeQuery(Source,
"SELECT [FirstName],[LastName],[BirthDate]
FROM [dbo].[DimEmployee]
WHERE YEAR([BirthDate]) >= @BirthY AND [FirstName] LIKE @FirstN+'%'",
[FirstN = firstName, BirthY = birthYear]
)
in
GoQuery
Can you tell me also on which place the name of the oracle Database has to be placed and where the name of the table and maybe other Oracle fields or parameters have to be set.
The purpose is to each excel values as a parameter in a sql to interrogate an Oracle Database.
Thank You In Advance
My best regards
Marc.

Comments

Processing

Post Details

Added on May 10 2021
0 comments
340 views