Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 240 Big Data Appliance
- 1.9K Data Science
- 450.4K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 546 SQLcl
- 4K SQL Developer Data Modeler
- 187.1K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 443 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
What is the syntax for connection an Oracle through a Power Excel Query

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.