Oracle Installation

We can install the necessary Oracle software on your server. This estimate includes a single installation on a single server. The price assumes all applicable users and privileges have been established prior to installation. We do not provide operating system patching or other OS system administration tasks.

Database Creation

Data Migration

One of our central tasks during the migration is to move objects and data from Sybase to Oracle. As a deliverable for this task, we will provide a completed Oracle environment, scripts and procedures used to complete the migration, and thorough documentation describing the steps necessary to complete the migration. Our goal is to create a repeatable process that can be used to refresh the Oracle environment on demand during the migration project, as well as a streamlined method of migration during the final "go live" phase.

Stored Procedure Conversion

One of the most time consuming tasks is converting Sybase stored procedures to Oracle. Depending upon the number of stored procedures to convert, this aspect of the migration may take several months to complete. If your organization lacks to expertise or resources to convert existing Sybase stored procedures, including reports and extracts, we can help. You decide how we can help you.

Our goal in converting stored procedures is produce efficient, error-free source code. In order to ensure efficiency in execution, our consultants may utilize advanced SQL and PL/SQL techniques when converting code.

IIS Configuration

We can install Advance in the desired Oracle database. The Advance version must match the Sybase version at the time of migration. The university or foundation is responsible for all AWA licensing, as well as procurring appropriate scripts and installation files.

CTG is not affiliated with SunGard and thus does not have the abiity to license Advance products.

AWA Installation

We can install Advance in the desired Oracle database. The Advance version must match the Sybase version at the time of migration. The university or foundation is responsible for all AWA licensing, as well as procurring appropriate scripts and installation files.

CTG is not affiliated with SunGard and thus does not have the abiity to license Advance products.

AWA Advance Upgrade

We are able to perform the Advance upgrade if necessary; however, we will be working under your licensing agreement as a contractor for your university or foundation. CTG does not have direct access to SunGard support if a problem arises.

AWA Home Pages

An essential step in providing a fully customized AWA application is the creation of individual home pages. These pages offer a unique look into Advance data based upon job role and necessary Advance functionality.

AWA Profiles

Profiles are critical in providing consistency among groups of Advance users. Proper planning for necessary AWA profiles is an essential step in customizing the AWA application. Profiles are created based upon client estimates or a CTG assessment.

AWA Customization

Customization of Advance Web Access includes the setup and configuration of the initial AWA environment, modification of SunGard supplied Forms, Pages, and Applications, and the development of custom .Net application components.

The customization of AWA may be a difficult task to estimate. Before a formal contract is agreed upon and a complete statement of work is produced, an assessment of your current Advance environment will be necessary.

AWA Assessment

We provide an assessment of your current environment to assist in your AWA migration project planning. The assessment evaluates the number and type of users currently using Advance Windows, along with projected AWA functionality. This evaluation is then used to determine the number of profiles and home pages to be created in the new AWA environment.

Report Creation

We can create new reports using Crystal Reports, Microsoft SQL Server Reporting Services, or AWA Form Reports.

This quote includes time used to create reports in the desired reporting environment; create any underlying database components such as tables, views, or stored procedures; and create report prompts. Prompts are typically created in one of three ways: (1) directly in the reporting environment, (2) as a Web Form in AWA, or (3) as a .NET control that is served by the Advance IIS Web Server.

For more information regarding report development, contact a CTG representative.

Report Upgrades

We have experience converting existing PowerBuilder reports to Crystal Reports, Microsoft SQL Server Reporting Services, and AWA Form Reports. The quote for services for this task depends upon the availability of pre-existing PowerBuilder source files and includes time allocated to updating reports including dependent PL/SQL stored procedures and PowerBuilder reports. This item does not include the creation of new reports from scratch; although, that is something that we can do if desired.

This quote includes time used to convert reports into the desired reporting environment; update the layout of reports; adjust any underlying database components such as tables, views, or stored procedures; and create report prompts. Prompts are typically created in one of three ways: (1) directly in the reporting environment, (2) as a Web Form in AWA, or (3) as a .NET control that is served by the Advance IIS Web Server.

For more information regarding report development, contact a CTG representative.

Report Conversion

We have experience converting existing PowerBuilder reports to Crystal Reports, Microsoft SQL Server Reporting Services, and AWA Form Reports. The quote for services for this task depends upon the availability of pre-existing PowerBuilder source files, and this option does not include any changes to underlying PL/SQL objects.

This quote includes time used to convert reports into the desired reporting environment, as well as time used to create report prompts. Prompts are typically created in one of three ways: (1) directly in the reporting environment, (2) as a Web Form in AWA, or (3) as a .NET control that is served by the Advance IIS Web Server.

For more information regarding report development, contact a CTG representative.

Introduction to Oracle

Duration: 1 Day

This course provides an introduction to Oracle's database environment including a breakdown of Oracle products, a discusion of available tools to access the database, and a look into the significant differences between Oracle and other leading database vendors.

This is a prerequisite for all other Oracle courses. While this course is not mandatory, a working knowledge of Oracle will be assumed for other courses.

Oracle Database Administration I

Duration: 3 Days

Discover the day to day responsibilities of an Oracle database administrator. The course includes an in depth discussion of the internal architecture of an Oracle database and how that architecture is relevant to a DBA. The course also introduces Oracle Enterprise Manager (OEM), object and system privileges, basic Recovery Manager features, and storage maintenance responsibilities.

Oracle Database Administration II

Duration: 4 Days

A continuation of DBA I, this course includes a more in depth look at back and recovery options using Recovery Manager, as well as tuning strategies and OEM advanced features.

Oracle Replication

Duration: 4 Days

This course offers a comparison of various replication alternatives in Oracle. Attendees receive hands-on experience setting up and configuring Advanced Replication, Streams, and standby databases.

PL/SQL Programming

Duration: 3 Days

This course begins with an accelerated introduction to PL/SQL syntax followed by discussions of Oracle supplied packages, cursor processing, collections, exception handling, debugging, and tuning.

Advanced SQL

Duration: 3 Days

Take advantage of advanced SQL constructs available in Oracle. Topics include grouping and aggregation, subqueries, analytic functions, and more. This content is useful to experienced developers new to Oracle, and it illustrates several techniques that can be used to overcome challenges when migrating from Sybase to Oracle.

Introduction to AWA

Duration: 1 Day

This introductory course defines the basic components of AWA including Applications, Pages, Forms, and Reports. Attendees are also exposed to fundamental AWA features and navigation schemes.

AWA Development

Duration: 3 Days

Developers learn how to customize their AWA environment. Topics include modifying baseline SunGard components as well as building and incorporting custom .Net objects into user-defined forms and pages.

Introduction to Web Programming

Duration: 4 Days

This course provides an accelerated look at fundamental web technologies including HTML, Cascading Style Sheets, and JavaScript. This course is a prerequisite for AWA Development.

Introduction to Crystal Reports

Duration: 4 Days

This course provides instruction detailing how to best use Crystal Reports, including installation, configuration, data access, group creation, function fields, summaries, and more. A comparison of Crystal Reports to PowerBuilder is also included due to the large number of Advance clients making the switch to Crystal.

Crystal Reports Server

Duration: 2 Days

This course focuses on Crystal Reports Server, including the user of dash board components.

Hourly Discount Table

The following table identifies current hourly consulting rates based upon the number of contractual hours necessary to complete your migration project.

Training Discount

Down Payment Discount

An additional 10% discount is applied to the quote total if the university or foundation agrees to provide an initial 20% down payment for the services specified.