Importing and Using Excel Data

Datasources, Spreadsheets, and Business Values

This simulation consists of five parts that are designed to cover the process of preparing and importing Excel data for use in Process Director. It will walk you through the process of:

Creating an Internal User Database Datasource object to prepare Process Director to import your Excel spreadsheet data into a table in the Internal User Database’s collection of SQL Server/Oracle tables.

1

Configuring your Excel spreadsheet and importing its data into Process Director.

2

Optionally modifying a Datasource to restrict the data it can access.

3

Building a Business Value to return the imported SQL data

4

Editing your Excel spreadsheet to update and reimport the data

5