Enterprise Modeling
|
-
Create a physical data model and design database objects such as tables, views, indexes, keys, procedures, and triggers.
- Generate a database via a script or live database connection.
-
Reverse engineer an existing database schema via a script or live database connection.
- Generate a database via ODBC using a script.
Note: See the
Sybase PowerDesigner
collection in the online bookshelf for more information.
|
Database Development
|
-
Create a database to use in developing applications.
-
Create a database service that enables connections to a database
server hosting multiple databases.
-
Create SQL files for organizing complex SQL statements.
-
Edit procedural objects, including stored procedures, triggers, and
SQL Anywhere/Sybase IQ event handlers and user-defined functions.
-
Execute procedural objects.
-
View execution plans and results from SQL queries.
-
Create Adaptive Server Enterprise nonsharable temporary tables.
-
Debug procedural objects.
-
Edit data in tables referenced in procedural objects.
-
Create a real-time messaging service.
-
Use Replication Server to develop a replication system and perform administrative tasks, including
creating and managing replication definitions, publications, articles, and
subscriptions.
-
Develop a real-time message service.
|
Data Federation
|
-
Connect to heterogeneous data sources, such as real-time,
historical, and third-party data.
- Use the tooling to develop federation capabilities to combine data
from heterogeneous sources. Provision or search for data sources and import or create
schema models to build data services.
|
Web Application Development
|
Create a Web application that uses a DataWindow object to retrieve,
present, and manipulate relational data.
|
Service Development
|
-
Create a database service that enables connections to a database
server hosting multiple databases.
-
Add a stored procedure or SQL query operation to a database service.
- Import a SQL query for SQL operation of a database service.
|