Welcome to Conduit! This user quick guide contains installation instructions and a step-by-step guide on adding your first connector, accessing your data, and building reports on your newly-connected data. It can be used for both the technical and non-technical audience. Let’s get started!


Product Features:

• Multiple protocols provide streamlined and secure connections to your data
• One simple interface to query relational and non-relational data
• Stateless, real-time connectivity enables direct access to data sources
• In cloud or on-premises deployment



Deploy Conduit:

Deploy Conduit in any environment with a few simple steps. 

To get Conduit, email us for the deployment script and manuals or get it from Azure Marketplace by deploying a cloud-based VM.

Get Conduit from Azure Marketplace

  1. Sign up for an Azure account at if you don’t already have one (it’s free!)
  2. Go to Conduit’s page on Marketplace:
    https://azuremarketplace.microsoft.com/en-us/marketplace/apps/bpcs.conduit?tab=Overview **placeholder URL. We’ll update this once we’re live on Marketplace

Make sure you’re signed in to Azure.

  1. Click Get It Now
  2. Follow instructions to deploy. You will be choosing a unique name in Azure for your Conduit deployment. The entire process should take about 20-25 minutes. Your URL will be:

[your unique ID in Azure].conduit.westus.cloudapp.azure.com



Log In

  1. Using the URL provided to you from deployment, go to Conduit in your browser.
  2. You will now see the Conduit Log in screen. Enter your credentials you used to sign up or (username is your email) or sign up as a new user in Conduit by pressing the Register New Account Your account will be confirmed pending admin approval.
  3. After the credentials are correctly added, press on the Sign In button to login and open Conduit.



Getting around Conduit

Site navigation in the management console of Conduit is on the top panel. As a user, you will be spending most of your time on the Connectors page, that is also the home page after you are successfully logged in.


For a System Admin, the top navigation bar contains:

  1. Connectors – The list of all connectors added to Conduit independent of the logged in user.
  2. Performance – Dropdown menu that contains information about Metrics, Event log, Cached Datasets and Clusters.
  3. Security – dropdown menu that is used when the admin needs to manage users: User Admin, AD Subscriptions and UserGroups.
  4. Help – The link for the Owner Manual/FAQ
  5. User settings – Details about licensing – and Log out.


For an End-User/Analyst, the top navigation bar contains:

  1. Connectors – The list of all connectors added to Conduit independent of the logged in user.
  2. Performance – Dropdown menu that contains information about Metrics, Event Log and Cached Datasets.
  3. Help – The link for the Owner Manual/FAQ
  4. User Log out.



Connectors

DB2 and MS-SQL require authentication against the external data source. The credentials are for a service account securely stored by Conduit, which ‘impersonates’ access from the end users via the published endpoint, regardless of the configured authentication type for the connector: Anonymous or Basic.


Add Connectors

Connect your first data source and start taking advantage of Conduit’s data acceleration abilities. Conduit currently supports Elasticsearch 5.x/6.x, Dynamics365, Azure/MS SQL, MySQL/MariaDB, PostgreSQL, Azure Blob Storage, IBM Db2, and any Odata services. Create as many connectors as you’d like and visualize your data in real time using the BI tool of your choice.

To add a connector, press the Add Connector Button.

The Add new connector wizard will open, and, before starting adding the details, the user must select the connector type by clicking on the connector name.


PostgreSQL:

About

PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

There is a wealth of information to be found describing how to install and use PostgreSQL through the official documentation. The PostgreSQL community provides many helpful places to become familiar with the technology, discover how it works, and find career opportunities. Reach out to the community here.

Guide

For your PostgreSQL datasource, have the following handy:

  • URL
  • Username of database
  • Password of database


After you select the connector type, the Add Connector wizard is opened. Steps to create the connector:

  1. Datasources: Define the connector type, name, description, and URL of data source
    1. Create the name for your connector:
      • The field is mandatory;
      • The name should contain only lowercase characters, no spaces, no special characters.
    2. Enter a description for the connector:
      • The field is not mandatory, and it will be visible in the list of connectors.
    3. Enter the URL for your datasource.
      • Verify the data that you entered and press on the Next arrow to go to the next step.
      • If you want to cancel creating the connector, press on the Close button.
  2. Authentication: - Define the method by which you want to authenticate external users. There are three Authentication types, all with impersonationSelect the Authentication type:
    1. Anonymous with Impersonation;
      1. Basic with Impersonation;
      2. Active Directory with Impersonation.

NOTE: External users are not required to provide any form of credentials.

Impersonation: provide the service account credentials used by Conduit to execute all runtime queries against the datasource.

b. Enter the Username and the Password.
Verify the data that you entered and press on the Next arrow to go to the next step.
c. If you want to cancel creating the connector, press on the Close button.