Getting Started
Try New OData API Instead
What is it?
The ToolWatch Reporting Cloud provides a comprehensive subset of organizational data through SQL Views. It can be used by any software that connects to SQL Server directly or through an ODBC connection.
Common usage scenarios
Export Job Cost & Billing data for integration with your accounting system
Analyze contents of kits
How do I connect?
A subscription to the ToolWatch Reporting Cloud provides your organization with:
IP address of Reporting Cloud server
SQL Server credentials
Accessing from SQL Server Management Studio
The ToolWatch Reporting Cloud server can be accessed from:
SQL Server Management Studio
Microsoft Excel
Microsoft Access
Custom .NET application
Any other application that can utilize ODBC connections
What you need
Using SQL Server Management Studio is as simple as connecting to our server and supplying your username and password.
Microsoft Excel has a data connection wizard which allows you to connect to a SQL Server and import data from our views
Microsoft Access also allows you to connect to external data sources for importing data
If you will be writing a custom .NET application, you will need to create a connection string in the format of
Data Source={servername};Initial Catalog={database};Uid={username};pwd={password}The values for servername, database, username and password will be supplied to any organization that subscribes to the reporting cloud.
Conventions in the Reporting Cloud Articles
ToolWatch tracks Tools & Equipment and Materials & Consumables. For brevity these articles will simply say tools or materials. Also, these articles will substitute the generic term "asset" whenever the discussion applies to both tools and materials.
These articles may sometimes classify assets into two types: uniquely-tracked (unique) and quantity-tracked (quantity). Tools and kits are uniquely-tracked. Materials and quantity tools are quantity-tracked.