Impact IDE provides a single solution built to help users accelerate analysis, design, development, and deployment. It makes creating and editing database objects fast and easy. The IDE allows you to view, build, edit and clone database objects, save your development and edits in a project, write and execute SQL from the SQL Editor, and much more...

Impact Database Designer is the heart of Impact IDE and consists of three forms in an easy to use and navigate multi-tabbed MDI environment. You can quickly define columns, tables, and views and Database Designer generates create, drop, alter, insert, update and delete statements. Along the way, Database Designer will help you follow normalization rules even if you don't know what they are. Without writing a single line of SQL you can:

• Automatically create a database.
• Define and maintain tables, views, and indexes.
• Select contextual options based on previous selections.
• Change a column definition and automatically change all tables and views containing that column.
• Search, sort, edit, delete and add data to a database
• Use database objects across applications.
• Move or copy data, objects or both between databases with XML
• View generated SQL scripts.

Object Explorer dynamically displays three different views of logically grouped database objects: ERD, Columns, and Objects. The Object Explorer displays a relational view of the entire data dictionary structure. Within each view, varying levels of detail are exposed for each object. Object Explorer

• ERD - Real time display of how database tables and view are related by their primary indexes (keys).
• Objects- displays database objects including their columns, indexes and index columns.
• Columns - displays data types, width, scale, precision, default value, and other information.
• Menus- Shows each menu group, menus within the menu groups, pages associated with the menus and other relevant information.
• Pages- Lists all virtual pages defined and shows the database objects associated with each page.
• View, edit, sort, or group data in tables in a tabular format in the Editor window.

The first step toward creating your solution is to set-up a project which is a container for individual objects. As you create objects, you may either build and execute the objects immediately or save and execute later. Most of the project creation is handled for you. All you have to do is tell Impact IDE where to store its files just like saving a document. The Project Explorer displays a list of all objects contained within the project.

• Contains logical groupings of all objects that are added to the project.
• Tree icons help you keep track of the status of each object.
• Add, open or clone existing database objects.
• Provides a full list of everything that may need to be copied to other databases to deploy the new functionality.

XML Transport makes copying data, database objects, and application between databases easy. The entire process is point and click. Simply choose what you want to export or import.

• Backup entire database, including data and database objects with one menu option.
• Selectively import objects within an XML file.
• Selectively export all data from selected tables.
• Use Database Designer to create view to export selective rows from selected tables.
• The XML file is viewable from a browser so you do not have to guess what is in the file.
• Point and click interface requires no programming knowledge.
• Database objects, menus, and pages are automatically created in the database when they are imported.
• Provides an easy means of automation integration between data sources
• Highly configurable and infinitely expandable.
• Create and save ad-hoc reports of your data using the export function.

Impact Application Designer exposes a proprietary data model that allows you to store business rules and processes in the database. Application Designer consists of two forms that define navigation menus and web pages in the database. Each menu option you define will generate a tree menu, list page, data filter page, and a data entry form or report. Menu and page definitions are stored as meta-data and are used by Impact GEN to generate the application as HTML.

• Define and maintain navigation menus and web pages used by Impact GEN.
• Point and click interface.
• Maintain complete control over what goes into your application.
• Define application structure and business logic.
• Define reports that can be displayed as HTML, Excel or Graphs.

The flexible nature of the architecture enables the interface and access privileges to be deployed at a very granular level. Each user can interact with an interface designed specifically for them and has access to the data relevant to their function. Impact IDE enables the collaborative enterprise to extend the value and reach of your applications beyond your organization. With this capability comes not only tremendous business value but also increased risk if it is not managed appropriately.

• Used by the Application Generator to provide layered access to a generated application.
• Role-based access control with delegated administration.
• Encryption of application transaction data while in transit or at rest.
• Broad and extensible auditing and reporting.