MSSQL
Last updated
Last updated
Provide the following information to create an MSSQL Data Connector.
Data Connector Name: Provide a user-defined name to identify the data connector.
Description: Provide connection details (Optional)
Username: Enter a Username (It should be the same as given in the connection server).
Password: Enter the Password (It should be the same as provided in the connection server).
IP/Host: Enter database server details (from where the user wants to fetch data).
Port: Provide the server port number.
Database Name: Name of the database where you wish to store data.
Click the ‘Save’ option.
A success message appears to confirm the connection.
Another success message appears to assure the creation of the new MSSQL Data Connector
The newly created MSSQL data connector gets added to the Data Connectors list.
Note: The user can use the following Environment Variables instead of the actual Username and Password to create the MSSQL Data Connectors.
Username: @ENV.MSSQLUSERNAME
Password: @ENV.MSSQLPASSWORD