 |
|
|
 |
What's New?
DIG 3.0! 3.0 was released in May and is available for download. Visit the VAI Support Site for an upgrade or trial version of the latest and greatest.
The 3.0 release introduced a new product line, architected to increase capability and flexibility.
The DIG 3.0 release includes two separate product lines:
|
|
The DIG Virtual Data Warehouse enables an organization to configure a single data handler (the DIG Server) to access all of its available data stores - databases, office files (in 60+ formats), web sites and e-mail archives - for simultaneous search and retrieval. The DIG Client is a simple search tool that gives users a single point of access to all of the data sources available to your organization.
Combined with the power of the DIG Server-to-Server technology, the DIG Virtual Data Warehouse encourages information sharing by creating a secure and selective data sharing environment
|
|
DIG Symphony is a new addition to the DIG product line. DIG Symphony is a low cost, integrated methodology for managing key data processing. The DIG Symphony Designer provides solutions for creating data quality programs, using tools for standardization, integration, parsing, enhancing, correcting, merging, matching, purging, and general cleansing of data.
The DIG Symphony Designer also includes a robust custom scripting tool called the DIG Script Editor. This tool allows anyone with programming knowledge to create custom scripts, using Visual Basic .NET or C#, to further define custom data handling events.
In the 3.0 release, the DIG Symphony Designer capabilities are embedded into the DIG Enterprise Manager allowing the DIG Administrator to apply transformations to data returned to users after a successful search.
|
|
|
 |
 |
…that a web version of the DIG Client is on its way?
Our latest development efforts revolve around the Web version of the DIG Client. Unlike the current "no-touch" web-enabled version of the DIG Client, this version is 100% Web compatible - letting users access it from any platform, using any browser.
The Web version of the DIG Client includes all the functionality of the installed DIG Client application, letting users execute Basic and Advanced searches as well work with, export and report on results.
This new feature will give DIG the utmost in flexibility. The Web version is currently in testing and is expected to be available shortly.
In the meantime, here's a sneak peek...
The Basic Search:
The Advanced Search:
Search Results:
Reports:
|
|
 |
Applying Transformations to DIG Views
As of the 3.0 release, the DIG Symphony Designer is embedded into the DIG Enterprise Manager. This allows the DIG Administrator to transform, standardize, and cleanse the data returned to users in results lists.
Because the DIG Symphony Designer is embedded, transformations are defined during the process of creating DIG Views. Once you have defined the connection to your database and created your View (specifying the fields to be returned to the user), you can set up transformations on any number of fields in the View.
For example, you might want to take a Phone Number field that is formatted as a string field and split it into 3 separate numeric fields.
This could require several transformations:
- Add 3 numeric columns
Use the Change Schema tool to add an AreaCode, Exchange and Number column, each formatted as a number type.
- Remove extraneous characters
Use the Replace Characters tool to remove the parenthesis from around the area code and change the space between the area code and exchange into a dash (-) to create a consistent delimiter between the values we want to split.
- Split the values
Use the Split String tool to set the columns into which the values should be separated as well as the character used to separate the values in the current column.
The transformed values display at the bottom of the window, in the preview area, so that you can review the values before applying and continuing.
The individual transformations are listed, in their order, in the Process Tree. Each transformation is executed as it is added. Remember that order can be important (e.g., the values can not be split into the new columns until the columns exist).
This is a very simple example of the types of transformations that can be applied to your data. The DIG Symphony Designer contains a wide range of tools that help you create a standard, quality set of data values for your users.
|
|
|
 |
|
