SharpCloud is a powerful tool as it’s a great way of visualising data that is normally silo’d across several line of business tools, making it difficult to show relationships between the data sets without SharpCloud.
QueryConnect makes connecting to other business systems easier, creating a simple way of importing data that lives elsewhere.
Data creation and import can be done one of three ways:
Creating and managing data directly in SharpCloud.
Allowing a set of data to be imported in an ad-hoc manner such as Copy and Paste or using QueryConnect.
Producing an automated flow between the business systems and SharpCloud using tools such as QueryConnect, Software Developers Kit (SDK) or the Rest API.
QueryConnect helps bridge the gap between Ad-Hoc and Automation as imports can be run on an individual basis and also be set up to be run as a batch file once there is an understanding of what is trying to be achieved.
Data sources include but are not limited to; Excel, Access, SharePoint List, SQL Server and an Open Database Connectivity source (ODBC). QueryConnect can also be used to connect to a SharpCloud story and copy data out of a story to an Excel sheet.
A great benefit to QueryConnect is that it can be used to connect to legacy databases (databases that are on-premises) and spreadsheets.
QueryConnect is only available for Windows.
To download QueryConnect, visit: https://www.sharpcloud.com/downloads
You can also access the page by clicking “Other Downloads” on the main SharpCloud Dashboard once signed in, underneath “Get Desktop App”.
Signing in to QueryConnect
If you authenticate into SharpCloud using username and password, those credentials will be the same to authenticate using QueryConnect
If you authenticate into SharpCloud using other routes such as O365/AzureAD/SAML, you will receive an email with the subject title of “Hurrah, Welcome to SharpCloud!”, and within this email there will be a password that will be used to access SharpCloud as well as the other tools such as QueryConnect.
Note: If you access SharpCloud authentication methods such as O365/AzureAD or SAML, that authentication method takes precedence when signing in to SharpCloud and SharpCloud for Desktop, but you will still require the password for QueryConnect.
The password can be changed in the profile menu when signed in to SharpCloud. If the password has been forgotten, a new password can be requested on the sign-in page by pressing “Forgotten Password”.
The password and username only have to be entered once into QueryConnect, permitting the password has not been changed. The username and password will repopulate once QueryConnect is opened.
The password and username are required at Stage 3 of the QueryConnect process and not required on initial start-up of the tool.
There is an “About” section available on the top toolbar, which provides useful links such as download tools and Knowledge Base Articles which provide further explanations about QueryConnect.