Click or drag to resize

Build an application with EETY

[This is preliminary documentation and is subject to change.]

ABOUT THIS GUIDE

The purpose of this tutorial is to help you understand how to build an analytic application with eety, using techniques for forensic accounting investigations. In this case, the data to be analyzed are extracted from an Ms Access database and a first digit analysis is run on the paid amount.

GETTING STARTED

Create an application solution:

  1. Launch Eety Desktop.

  2. Click NEW in the file toolbar.

  3. Optionally, change the destination folder in the file dialog box.

  4. Fill in a name for the solution file (without any .eety extension) in the file name text box.

  5. Click Open.

    The solution workspace opens its Solution Explorer on the right side and a start page in a New Solution window.

    This start page simply depicts steps to walk through building an application:

    • Add source and target connections,

    • Map sources and targets with the logical business model,

    • Add an analysis workflow.

openfiledialog
STEP 1: ADD SOURCE AND TARGET CONNECTIONS

Add Microsoft Access connection

  • Access 2007 database with the Invoices Paid table can be exported from Mark J. Nigrini site.

  • Eety provides an Access connector to extract the table

    To create an Access connection:

    1. Right click on Connection, in Solution Explorer.

    2. Expand the new connection menu.

    3. Select the Ms Access connector.

    4. Fill the dialog box with the relevant values.

      Note Note

      A relative file path also works.

    Tutorial-Quick Start 1 Access

Check connections and data

  1. Double click on Invoices in Solution Explorer.

  2. Expand the tree nodes in Connection Explorer on the left side.

  3. Double click on tblInvoicesPaid.

  4. Check the rows in the bottom Sample tab.Fill the dialog box with the relevant values.

Tutorial-Quick Start 1 Check Data
STEP 2: MAP SOURCES AND TARGETS WITH THE LOGICAL MODEL

Basic concepts

One single model shares its elements with all the components in the application. This is a logical business model with tables, columns and relationships mapped to the data sources corresponding elements. At runtime, data extracted from the data sources is stored into these elements, starting an integration or analysis pipeline.

In this example, we will:

  • Create a new extraction mapping.

  • Create and map a new class with the Access tblInvoicesPaid table.

  • Rename the tblInvoicesPaid class.

To create the extraction mapping

  1. Right click on the Mappings node, in the Solution Explorer pane.

  2. Add a new Extraction type mapping.

To create and map a new table

  1. Optionally, double click the New mapping node in Solution Explorer pane.

  2. Expand the Invoices node in the Data Sources pane.

  3. Click the tblInvoicesPaid table below main.

  4. Click add+map-classifier 24x 24 in the toolbar to create and map a new table.

Tutorial-Quick Start 1 Mapping

To rename the tblInvoicesPaid table

  1. Double click the New Model node in top of Solution Explorer.

  2. Expand InvoicesPaid node in Model Explorer.

  3. Select tblInvoicesPaid, press F2 and rename it Invoice.

  4. Rename the New Model node Invoices.

STEP 3: ADD AN ANALYSIS WORKFLOW

To add an analysis workflow:

  1. Right click on Workflows, in Solution Explorer.

  2. Add an analysis worfklow.

  3. Right click the new workflow node and rename it Analysis.

Tutorial-Quick Start 1 Workflow
STEP 4: CREATE A REPORTING WEB APPLICATION

Basic concepts

We want to release all the analysis reports as html views and browse them into a dedicated web site.

To create a web application

  1. Expand the Analysis node in Solution Explorer pane.

  2. Double Click Report.

  3. Click Invoices in the model tree on the left pane.

  4. Click Add new button on the right of the toolbar.

    Tutorial-Quick Start 1 Wizard
  5. Select Web Application on the left of the Reporting dialog box.

  6. Click the site templates button on the bottom of the box.

  7. Select the jquery+bootstrap+highcharts.etpl template file in the dialog box.

    Tutorial-Quick Start 1 Etpl
  8. Click Open.

  9. Fill the dialog box with the relevant values:

    Tutorial-Quick Start 1 Web App
  10. Click OK.

  11. Check the added items:

    Tutorial-Quick Start 1 Web App 2

To add an auto start

  1. Click Invoices in the model tree on the left pane of the Reporting stage page.

  2. Double click the reporting-webstart button in the bottom toolbar of the center pane.

    Tutorial-Quick Start 1 Auto Start
  3. Click the edit-delegate 16x 16 button on the right of Start Application in the listbox.

  4. Input parameters as shown below:

    Tutorial-Quick Start 1 Auto Start 2
STEP 5: TEST THE APPLICATION

To test the application

  1. Click debugger 16x 16 in Solution Explorer toolbar.

  2. Click workflow-start 16x 16 in Test New Application.

  3. A default browser instance should be started.