WebSphere Studio Application Developer part 5 provides integrated development tools for all e-business development roles, including Web developers, Java developers, business analysts, architects, and enterprise programmers. The customizable, targeted, role-based approach of WebSphere Studio Application Developer will be characteristic of all new products built on the WebSphere Studio Workbench. It is well integrated with WebSphere Application Server and provides built-in server test environments that can be used for testing and profiling Web applications | Relational database tools The database tools provided with the WebSphere family products allow you to create and manipulate the data design for your project in terms of relational database schemas. You can explore import design and query databases working with a local copy of an already existing design. You can also create an entirely new data design from scratch to meet your requirements. The database tools provide a metadata model used by all other tools that need relational database information including database connection information. In that way tools although unaware of each other are able to share connections. The SQL Statement Wizard and SQL Query Builder provide a GUI-based interface for creating and executing SQL statements. When you are satisfied with your statement you can use the SQL to XML Wizard to create an XML document as well as XSL DTD XSD HTML and other related artifacts. The relational database tools support connecting to and importing from several database types including DB2 Oracle SQL Server Sybase and Informix . XML tools The comprehensive XML toolset provided by the WebSphere Studio family of products includes components for building DTDs XML schemas XSD and XML files. With the XML tools you can perform all of the following tasks Create view and validate DTDs XML schemas and XML files. Create XML documents from a DTD from an XML schema or from scratch. Generate JavaBeans from a DTD or XML schema. Define mappings between XML documents and generate XSLT scripts that transform documents. Create an HTML or XML document by applying an XSL style sheet to an XML document. Map XML files to create an XSL transformation script and to visually step through the XSL file. Define mappings between relational tables and DTD files or between SQL statements and DTD files to generate a document access definition DAD script used by IBM DB2 XML Extender. This can be used either to compose XML documents from existing DB2 data or to decompose XML documents into
