Oracle.Database

Introduction to Oracle.Database function

The Oracle.Database function is part of the Power Query M language. It’s used to connect to and retrieve data from Oracle databases. This function takes several parameters such as server, database, username, and password. Once connected, you can use other M functions to query and transform data.

M Code Behind Oracle.Database

The M code behind the Oracle.Database function is quite complex. It includes several steps to connect to the Oracle database and retrieve data. The following is a breakdown of the M code behind the Oracle.Database function:

1. Create a connection string: The first step is to create a connection string. This string includes information about the Oracle server, database, username, and password. The connection string is created using the following M code:

let

server = “OracleServerName”,

database = “OracleDatabaseName”,

user = “OracleUserName”,

password = “OraclePassword”,

connectionstring = “Provider=OraOLEDB.Oracle;Data Source=” & server & “;User Id=” & user & “;Password=” & password & “;”

in

connectionstring

let

connectionstring = [connection string created in step 1],

db = Oracle.Database(connectionstring)

in

db

let

db = [database connection created in step 2],

employees = db{[Schema=”dbo”,Item=”Employees”]}[Data]

in

employees

let

employees = [data retrieved in step 3],

transformed = Table.TransformColumns(employees,{{“Salary”, type number}})

in

transformed