Connector Adapters

Board Connector Adapters allow to create a connection to a Cloud Data Provider or to a non OLE DB Data Source.

Available data sources

OData

OData (Open Data Protocol) is a standard data access protocol commonly used by on-premise and cloud data sources to expose data. Several non SQL databases as well as cloud and on-premise ERPs, CRM solutions, Financial Accounting solutions and Internet Data Providers expose Data through OData webservice.

 

REST

Rest APIs are tradionally adopted by Websites and Web Aapplications to expose data as live data services. For example web services from Google, Bloomberg, Dun&Bradstreet, Amazon, Twitter,Linked-in and many more. Note that such data services be limited or require subscription.

Salesforce

It Allow to connect to Salesforce.com data. A Salesforce.com account is required.

YAHOO (Places, Finance, Weather)

It Allows to connect to the following Yahoo data services:

> Finance: currency exchange rates, stock quotes, market data and more.

> Weather: access weather forecast and alerts for cities through the world.

> Location: access longitude and latitude for cities through the world.

Google Bigquery

It allows to access Google Bigquery service retrieving  data using super-fast, SQL-Like queries , using the Google's Infrastructure. Google Bigquery service requires an user account credential.

 

How to create a Datareader using an existing Extract Query

image340.jpg

 

Click on the "New Protocol" Icon of the Data-Reader "Connector" Tab , the following configuration window prompts out :

 

image343.jpg

 

Select in the MDB Panel those Board Database Objects (Dimension and Info-Cubes) you like to feed. Select from  Data Source Panel the Extract Query you like to use clicking in the check button. Available Query are categorized by Data Source Type.

The available fields of the Query are listed in the Bottom Left Corner Window.

Select the proper field in the drop down list for each Board Object. Save and Run the Data-reader like any traditional Data-Reader protocol.

 

How to create a New Extract Query

From the Data Source Tab click on the "New" Icon.

 

image305.jpg

 

 

The Extract Query Manager prompts out.

 

image344.jpg

 

 

 

The Query Extract Manager provides an interface to create and manage Connections to Data Providers as well as Data Extract Queries.

The Data Extract Query is the result set of data that is going to be load into the BOARD database. In order to create an Extract Query a Data Source connection must exist.

 

To create a Data Source Connection click on the Wizard Icon "Data Source Connection"

image345.jpg

 

In the "My Connection" List Box Existing Connection are listed :

> to edit an existing connection, select the Connection Name and click on Edit Button

> to delete an existing connection, select the Connection Name and click on Delete Button

> to create a new connection, click on New Button :

 

image346.jpg

 

Choose the Data Source Type you are going to connect.

Provide the Settings that are required.

Click Ok and Save. The Connection is now available to create a New Xtract Query.

 

 

Note:

The Connection Settings may vary a lot from Connection Type to Connection Type. Such information are normally provided from the data service provider when the user account is given.

 

To create a  Extract Query click on the Wizard Icon " Extract Query"

 

image347.jpg

In the "Extract Queries" List Box Existing Queries are listed :

> to edit an existing Query, select the Query Name and click on Edit Button

> to delete an existing Query, select the Query Name and click on Delete Button

> to browse Data from an existing Query, select the Query Name and click on Browse Data Button

> to create a new Query , click on New Button :

 

image29.gif

> select an Existing Connection

 

image348.jpg

(Sample of OData  Extract Query)

 

Then Name the Query, connect to the Data Source and choose the "Table" and "Fields" you like to have in the Query Data Set.

The Query Sentence is provided in the Query Text box; you can edit it manually .

Click on the Test Extract Query for confirmation and Data browsing.

When ready click on the OK Button and Save. The Extract Query is now available in the Data Source Tab of the Data Reader Protocol.