SharpCloud Enterprise Connectivity

The SharpCloud SDK provides a mechanism for other IT systems to communicate directly with the SharpCloud database via an object model based interface. 

SharpCloud also offers a Representational State Transfer (REST) API that can be used to access SharpCloud data using modern web programming tools. ODATA is our preferred way to deliver a RESTful service as it is an open industry standard that offers flexibility to make customised requests without overcomplicating the REST endpoints 

The SDK and API can be used to both read data from and write data to SharpCloud. All data objects within a SharpCloud story such as items, attributes and panels can be accessed via these programming interfaces.  

SharpCloud QueryConnect, our server and desktop integration tool built using our own SDK, now has additional connectivity options making it possible to access integrations with over 190+ connectors from CData. 

QueryConnect allows you to write SQL queries (as simple or as complex as you need) to read from your Line of Business systems and databases and load that data to your SharpCloud stories. Connections in QueryConnect can be batched together and scheduled to automate the integration process. 

For the complete list of possible connections that can be utilised with QueryConnect see https://www.CData.com/drivers/ 

Combining the capabilities of the OData driver from CData with the SharpCloud API it is now possible for customers to read data from across their SharpCloud stories with standard SQL statements. The CData OData driver https://www.CData.com/drivers/odata/ can be used by a wide range of BI, Reporting, Analytics, ETL Tools, and Custom Solutions to read data from SharpCloud and also write updates if desired to Line of Business systems.  

Utilising the SharpCloud API and widgets these sample stories contain beta connectors for Jira, SharePoint Lists, and Microsoft Project Server with replication and synchronisation of items in the SharpCloud story with your chosen data source. 

Use these connectors to explore relationships in lists of data or gain oversight of an activity across a portfolio of projects.