DriveWorks Pro 22

Integration

Databases

DriveWorks can read and write data from any database with an ODBC driver as well as reading data natively from Microsoft SQL Server.

Read Database Data

• QueryData
• QueryDataValues
• DbQuery

Write Database Data

• ODBC Data Export
• SQL Server Data Export

Connect to a Database to Automate DriveWorks

• DriveWorks Autopilot Database Connector

Importing Data

DriveWorks can import data from a range of file formats to create Specifications or use in rules.

Import Data

• Import structured XML or Tab delimited formats into a Specification
• Upload Control

Import XML data

• Import Data From XML Into Constants And Controls

Import TXT files

• Import Lines From a Text File into an Existing Simple Table
• Import Lines From a Text File into Constants and Controls

Import Excel Data

• Import Multi Column Named Sheet from Excel into Constants and Controls
• Import Named Range Values From Excel Into Constants And Controls
• Import Named Sheet From Excel Into An Existing Project Table
• Import Named Sheet From Excel Into Constants And Controls

Monitor a Folder for new files that will Automate DriveWorks

• DriveWorks Autopilot Folder Watcher

Exporting Data

DriveWorks can export data to a range of file formats to further integrate with other systems.

Export Excel Data

• Export a Table Array To Named Range in Excel
• Export All Control Names To Named Sheet in Excel
• Export Control Values To Named Sheet in Excel
• Export/Calculate/Import To and From Named Ranges in Excel
• Export/Calculate/Import To And From Named Sheets In Excel
• Create a Microsoft Excel document with driven data.

Export XML data

• Drive data into a structured XML document.

Export TXT files

• Export A Table Array To A Text File
• Export Control Values And Constants To Text File
• Create a Text document.

Export JSON data

• Drive data as a JSON document.

Web Services

Send and receive data from DriveWorks using web services.

Using a Specification Task

• Send HTTP Request

Pass Data Securely from Client to Client

• DriveWorks Live Integration Theme

Connect to a Web Service to Automate DriveWorks

• DriveWorks Autopilot Web Service Connector

Plugins and PowerPacks

Add features and specialized functionality with DriveWorks PowerPacks and automatically installed plugins.

• Specification PowerPack
• Image PowerPack
• SOLIDWORKS PowerPack
• SOLIDWORKS PDM Professional Plugin
• PDF Plugin
• eCommerce PowerPack
• CAMWorks PowerPack
• SOLIDWORKS CAM PowerPack
• SYSPRO PowerPack
• Salesforce PowerPack

DriveWorks API

DriveWorks is built on its own fully documented API. This makes it easy to integrate DriveWorks with any of your company systems.

We have created a Software Development Kit (SDK) that includes the reference assemblies that you will need, the complete documentation as well as some Visual Studio Project Templates.