MS Sql Olap

Provide the following information to create an MSSQL OLAP 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).

• Address Type (IP/Host): As per the selected Address type, a field appears below. The user needs to 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.

• The success messages appear to confirm the connection and creation of a new connector.

• The newly created MSSQL OLAP data connector gets added to the Data Connectors page.