Discover how a bimodal integration strategy can address the major data management challenges facing your organization today.
Get the Report →Analyze Business b-ridge Data in Infragistics Reveal
Use the CData Connect Server to create an OData API on top of Business b-ridge data and visualize live Business b-ridge data in Ingragistics Reveal.
Reveal is a data visualization solution provided by Infragistics and can be paired with the CData Connect Server and Business b-ridge Connector to build dynamic dashboards from live Business b-ridge data. The CData Connect Server creates a virtual database for Business b-ridge and can be used to generate an OData API (natively consumable in Reveal) for Business b-ridge. In this article, we walk through connecting to Business b-ridge in Connect Server and connecting to Connect Server from Infragistics Reveal to create a simple dashboard.
Add a Connect Server User
Create a User to connect to Business b-ridge from Reveal through Connect Server.
- Click Users -> Add
- Configure a User
- Click Save Changes and make note of the Authtoken for the new user
Connect to Business b-ridge from Connect Server
CData Connect Server uses a straightforward, point-and-click interface to connect to data sources and generate APIs.
- Open Connect Server and click Connections
- Select "Business b-ridge" from Available Data Sources
- Enter the necessary authentication properties to connect to Business b-ridge.
When connecting to Business b-ridge, CompanyKey, ProjectKey, and SubscriptionKey are required.
To obtain the SubscriptionKey, follow the steps below:
- Log in to Business b-ridge API Protal and go to "Profile" in the "Your name" menu.
- In your subscription section click "Main Key" to retrieve their respective values.
Authenticate to Business b-ridge Account
Set the following connection properties to connect:
- CompanyKey: Set the Business b-ridge Company Key of the connection destination.
- ProjectKey: Set the Business b-ridge Project Key of the connection destination.
- SubscriptionKey: Set the value "Subscription Key".
- Click Save Changes
- Click Privileges -> Add and add the new user (or an existing user) with the appropriate permissions (SELECT is all that is required for Reveal).
Add Business b-ridge OData Endpoints in Connect Server
After connecting to Business b-ridge, create OData Endpoint for the desired table(s).
- Click OData -> Tables -> Add Tables
- Select the Business b-ridge database
- Select the table(s) you wish to work with and click Next
- (Optional) Edit the resource to select specific fields and more
- Save the settings
(Optional) Configure Cross-Origin Resource Sharing (CORS)
When accessing and connecting to multiple different domains from an application such as Ajax, there is a possibility of violating the limitations of cross-site scripting. In that case, configure the CORS settings in OData -> Settings.
- Enable cross-origin resource sharing (CORS): ON
- Allow all domains without '*': ON
- Access-Control-Allow-Methods: GET, PUT, POST, OPTIONS
- Access-Control-Allow-Headers: Authorization
Save the changes to the settings.
![Configuring CORS settings](../articles/connect-setup-8.png)
Create a Dashboard in Reveal
With Connect Server configured, we can visualize Business b-ridge data in Reveal.
- Log into Reveal and click Dashboards -> New
- Click Data Source -> OData Feed
- Specify the Connect Server API endpoint URL (found in API -> Discovery -> Base URL), for example: CONNECT_SERVER_URL/api.rsc
- Select Generic Credentials and specify the Connect Server username and authentication token
- Select the entity you wish to visualize
- Select fields and choose a chart type
More Information & Free Trial
At this point, you have created a simple dashboard from live Business b-ridge data. For more information on creating OData feeds from Business b-ridge (and more than 150 other sources), visit the Connect Server page. Download a free, 30-day trial and start working live Business b-ridge data in tools that consume OData APIs.