MS SQL | Power Query |
This plugin allows to access the mssql database by using multiple authentications sql server authentication and microsoft entra multifactor authentication and also we can import data from excel file to mssql database Author
|
Authentication Type
1. Microsoft Enrta MFA(Multifactor Authentication)
Input (Required)
- Server - The server name or IP address where the MS-SQL database is hosted.
- DBname - The name of the database to which you want to connect.
- Optional:
* MSSQL String
Parameter setting examples(diagrams)
2. SQL Server Authentication
Input (Required)
- Host- The host name or IP address of the MS-SQL server
- User- The username with access to the database
- Password - the corresponding password for the user
- DBname - the name of the database to which you want to connect
- Port - the port on which the MS-SQL server listens.
- Optional:
* MSSQL String
Parameter setting examples(diagrams)
3. Data Input
Input (Required)
- Host/Server- The hostname or server name where MS-SQL is hosted.
- User - The database username
- Password - PAssword associated with the database user
- DBname - The target database where data will ve imported
- Port - The port MS-SQL server listens required with host.
- Optional:
* MSSQL String
Parameter setting examples(diagrams)
Return Value
- Stirng(default)
Return code
- 0 success
- 99 Exceptional caes
Ouput Format
You may choose one of 3 output formats below,
- stirng(default)
- CSV
- File