Design Studio

PURE DEVELOPMENT
The SQData Design Studio is an easy to use Graphical User Interface (GUI) that enables you to quickly develop and maintain your data movement interfaces. From the start, the intent of our Design Studio was to significantly reduce the time required to develop and deploy data integration interfaces by overlapping some of the design and development tasks. We also kept our 'Power Users' in mind which resulted in the elimination of unnecessary key strokes and mouse clicks.

The Design Studio includes several time-saving features that allow you to:

• Create relational DDL, XML and C/C++ structures from any SQData supported data
   structure such as a COBOL copybook or relational DDL.
• Create relational database load utility control statements based on the content of the
   data movement interfaces.
• Create common procedures and share them between projects
• Multi-level array handling (repeating groups) of source data store records/rows
• Migrate objects to/from different environments

The Design Studio's integrated metadata repository is used to store the critical information regarding your corporate databases/files along with the business rules associated with your data. Our metadata repository can be any ODBC compliant relational database of your choice. In addition to the reports supplied with the Design Studio, you have the ability to run your own SQL queries against the underlying metadata to generate custom reports.