Data Sources & Connectors

Features

• Robust processing. The connectors consist of optimized queries that work in parallel and incrementally to harvest only the required and changed data from your data repositories. Data is transported in batches, so should anything break (like an unscheduled SCCM reboot), the connectors will just pick up where they left off and continue. Data is loaded into feeder tables which enable offline processing and immediate switching, meaning no downtime as the data updates.

• Configurable and intelligent data refresh using parallel and incremental data processing methods. Only load the data you actually need. You can configure connector rules to harvest specific data (for example, only return devices that have been active in the last 60 days). Dashworks connectors use incremental processing designed to place the minimal amount of load on your source repositories, and the minimal amount of data into the Dashworks platform. The connectors can also be configured to pull from the same tooling different data sets, such as application usage or package entitlements from SCCM rather than installed application data.

• Out-of-the-box certified data connectors for all of the common IT management tools such as Microsoft SCCM (multiple versions), Exchange, Active Directory, and dozens of other third-party data connectors.

• CSV file handler to consume additional organizational and other project-relevant data. Anything that's not already in the source systems can be appended into the data set using a CSV upload. Dashworks also has the ability to import critical data residing in other external systems such as HR and asset databases using supported CSV format files. This could include (but is not limited to) user contact details, computer warranty dates, application owners, location hierarchy, business unit hierarchy, PC ownership overlay, web application feeds, and much more. Dashworks also links to dynamically-generated project information such as application workflow readiness status or mailbox migration success flags.

• Bespoke connectors. Dashworks supports the ability to create bespoke connectors by creating a custom view in your data set and transferring the customized data directly into a Dashworks table (known as a direct insert). This way you can automate the data harvesting process, make it refreshable, and avoid manual CSV uploads.

• Wizard-driven management. Our connectors are easy to configure, even for non-technical power users. You only need a read-only service account. Just point it at the appropriate data repository, schedule when you want it to run, and Dashworks will do the rest.

• Error reporting & rule-based data cleansing. Dashworks can also clean and consolidate your data on the way in. For example, a messy HR feed might create three locations called "Hawley Street", "Hawley St.", and "Hawley St" but by creating rules, you can tell Dashworks that this refers to only one location.