The third type of data connector is the SQL connector. This connector allows you to access a SQL database and get the desired data using a SQL query. After adding a SQL connector, the data source management dialog will be opened.
You can edit the name of the data connector in the text box marked yellow. To generate a connection string to connect to your database, press the red marked 'Create' button. After establishing a connection to the database by generating a connection string, you can add an SQL query by pressing the green marked 'Create' button.
Set up SQL connector - main dialog
After setting up the connector you can mask specific columns of your data source to protect proprietary data like passwords.
Create Connection String
SQL connector - Connection Properties dialog
SQL Query Designer used to create SQL queries