Connectors

  

Navigation: Administrator -> Connectors.


This is the existing screen before 5.4.7 version where all the database connections and cloud connections are created and listed. Earlier, Data Pipelines aka Cloud Connectors were listed in this screen itself along with the database connections and required source connection was implicit to the Cloud Connector creation itself.


 Create Connector

Create button shows all the available database type connections and Cloud Connections that the user can create as shown below



Click on any of the cloud connector to provide the authentication details with which the cloud connector can get validated as shown below:

For example, the below example shows how a Cornerstone source cloud connection can be created by clicking on the Cornerstone icon available in the above-mentioned screenshot



Connector Name is the name with which the cloud connector can be saved with.

Given the required credentials, click on “Test Connector” that validates the cloud connector details and then click on “Save” to save the cloud connector as mentioned in the above screenshot.

Note: No destination database will be available to configure for the cloud connector as this screen just creates a Source Cloud connector that can be used at the time of creating a Data pipeline.

Once the Source Cloud Connector is created, the Connectors screen will display the created Cloud connector.


Create Database connection 

User can create database connection by giving mandatory details which are required to save connection.

User can validate the connection by clicking on  test connector.



Search Connectors

Filters section in Connectors screen will show 2 options as shown below



  Connector Info

Clicking on the Info icon will show Details and Usage sections as shown below


Share Connectors

User can share their owned connections to the other users.


 Share Cloud Connection

  User can share the Cloud Connections to the other users so that they can utilize it as source connection for creating data pipelines 


Share Database Connection


User can share the database connections to the other users




RedShift Connector


The Redshift connector allows querying and creating tables in an external Amazon Redshift cluster. 

This can be used to join data between different systems like Redshift and Hive, or between two different Redshift clusters. Now redshift connector is included in SplashBI for all kinds of deployments which was earlier only in AWS support.

To create a RedShift Connector:

  1. Navigate to Admin > Connectors. 
  2. Click on Create icon to display a Create Connector window.
  3. Click on RedShift Connector then create connection window will open, enter required details.
  4. Click Save.




Redshift Connector Parameters


  • Connector Name: Provide a name for the connector. 


Enter the mandatory details like connection user, password, host name, port, URL, database name, schema name and click on save.



SnowFlake Connector


The Snowflake data platform is not built on any existing database technology or “big data” software platforms such as Hadoop. Instead, Snowflake combines a completely new SQL query engine with an innovative architecture natively designed for the cloud. 


To create a Snowflake Connector:

 

  1. Navigate to Admin > Connectors. 
  2. Click on Create icon to display a Create Connector window.
  3. Click on snowflake Connector then create connection window will open, enter required details.
  4. Click Save.




Snowflake Connector Parameters


  • Connector Name: Provide a name for the connector. 


Enter the mandatory details like connection user, password, hostname, port, URL, database name, schema name and click on save.

Connection Details Masking


Setting that allows the SplashBI user to mask or unmask the connection details for non-admin user view.


Setting Name - Connection Details Masking


Description - Set this to On to mask the connection details like Hostname, Username, port, sid, and database name will be masked for non-admin user view


By default, the Connection Details Masking setting should be off.