Connect SharpCloud stories directly to your database with SharpCloud QueryConnect and build, refresh and automate your stories from your business data. SharpCloud is a great way of visualizing data that is normally siloed across several line of business tools and more importantly, making sense of it.
It’s now even easier to integrate, move and analyze data in a SharpCloud story using our new Enterprise Connectivity, powered by CData.
Data is often held in multiple locations and multiple formats. SharpCloud QueryConnect, our server and desktop integration tool built using our own SDK, is a powerful tool that allows users to connect different line of business tools such as Microsoft Access, SQL Databases and many others (including Legacy Databases), to import data into a SharpCloud story and keep it synchronized.
QueryConnect makes connecting to other business systems easier, creating a simple way of importing data that lives elsewhere. SharpCloud QueryConnect now has additional connectivity options making it possible (with a little bit of work!) to access integrations with over 190+ connectors from CData.
For the complete list of possible connections that can be utilised with QueryConnect, see https://www.CData.com/drivers/
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 into your SharpCloud stories. Connections in QueryConnect can be batched together and scheduled to automate the integration process.
There are some great features including:
- Group queries together using Folders and Sub-Folders. This allows multiple queries to be run collectively together as a group, instead of independently having to run each query.
- Items and attributes, relationships, url resources and panel data can be imported into a SharpCloud story using QueryConnect.
- Ability to export queries which means that any connections/folders that you have created can easily be shared with other QueryConnect users, cutting down on duplication of effort.
To download the latest version of QueryConnect, click HERE. There are also Knowledge Base articles detailing more information about QueryConnect, which can be found HERE.
SharpCloud is a dynamic application and live data is constantly updated and reported at the right frequency, saving a lot of time in monthly reporting. Everyone is in the same digital space and so is their data. Data can be viewed, edited, updated and changed from a variety of devices, from anywhere and in real-time, meaning you’ll never be using out-of-date information again.
Create better transparency and visibility across your business.