MS-SQL-6.1216.1643
 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