1 of 7

Others

This section describes steps to configure the remaining Data Connectors.

Check out the given walk-through on how to create an API Data Connector under the Data Center module.

Please Note: Consider the above illustration as a sample video. The similar steps can be followed to create other connectors under the API category.

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.

Data Store

Provide the following information to create a Data Store Data Connector.

Data Connector Name: Provide a user-defined name to identify the data connector.
Data Store Service: Select a data store service from the drop-down list.
Click the ‘Save’ option.

A message appears to confirm the creation of the new data connector.

The newly created Data Store data connector gets added to the Data Connectors list.

OData

Provide the following information to create an OData Data Connector:

Data Connector Name: Provide a user-defined name to identify the data source.
Description: Provide connection details.
Database Type: Select the Database type using the drop-down menu in which you wish to store the data(OData V1-V2/OData V3-V4).
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).
Base Url: Enter Service Root URL or Base URL.
Click the ‘Save’ option.

The success messages appear to assure the new OData connection.
The newly created OData Data Connector gets added to the Data Connectors list.

Spark SQL

Provide the following information to create a Spark SQL Data Connector:

Data Connector Name: Provide a user-defined name to identify the data source.
Description: Provide the 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.
Click the ‘Save’ option.

The newly created Spark SQL Data Connector gets added to the Data Connectors list.

AWS Redshift

Provide the following information to create an AWS Redshift Data Connector:

Data Connector Name: Provide a user-defined name to identify the data source.
Description: Provide the Connection Details.
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 the data.
Click the ‘Save’ option.

The success messages appear to assure the data connection, and the newly created AWS Redshift data connector gets added to the Data Connectors list.

SAP HANA

Provide the following information to create an SAP Hana 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.
Click the ‘Save’ option.

The newly created SAP Hana data connector gets added to the Data Connectors list.