Tuesday, November 25, 2014

AppWorx User Manual

Online

AppWorx
Version 5.1 (2002)
User Guide
AppWorx Corporation

A Modular Approach to Operations

AppWorx replaces scripts with an object-oriented approach to operations.

AppWorx provides a complete background-processing management system. With
AppWorx, you can do all the traditional batch management tasks, as well as submit jobs
and view output.

However, instead of writing scripts to perform tasks, you create AppWorx modules that
run programs. You combine modules to create chains. You create a schedule for each chain
(or for each module if you wish) using a full complement of scheduling tools including
custom calendars and execution conditions.
As with all modular systems, you create individual objects once, then use them in different
combinations to accomplish a variety of tasks. In the context of batch management, this
can save you hours of time compared to writing, debugging, and maintaining scripts. A
diagram of the AppWorx modular approach to operations is shown in Figure A.

A Different Way of Thinking

In a traditional operations environment, scripts drive operations. Scripts incorporate the
information required to run one or more programs on a set schedule, direct output, and
handle exceptions. The problem with scripts is the required time maintaining them when
the system changes. For example, if a printer definition changes, you must change it in
every script.

AppWorx takes the individual components of a script such as programs, schedules,
printers, and variables, and lets you define them as discrete objects. You can then combine
the objects in an unlimited number of combinations to handle your operations. The
advantage is being able to change an object in one place, and have the changes roll over to
every use of the object.

Automic: KEY REQUIREMENTS FOR A JOB SCHEDULING AND WORKLOAD AUTOMATION SOLUTION

Overcoming Today’s Job Scheduling Challenges
While traditional batch job scheduling still has a place in many enterprises, the task is
far more complex than it used to be due to the use of various computing platforms,
multiple computing environments, and business processes that run 24x7. Add to that
the complex interdependencies that often exist between different processes and the
frequent need to trigger jobs dynamically, based on changing circumstances. It’s clear
that the requirements for a traditional job scheduler has evolved into a broader workload
automation capability to meet today’s complex requirements.

But what are the key capabilities you actually need to address a modern day demands
of an enterprise job scheduling or workload automation solution? We’ve collated the
top requirements from global enterprises during the past 15 years. All of which have
successfully automated their core data center processes supporting their core business
applications and services. As such, they were able to reduce processing time by 70% and
eliminate 90% of IT process errors whilst reducing manual effort by 90%.


If you are looking for a job scheduling or workload automation solution that is built to meet
the demanding enterprise requirements of a modern day business, then it’s important to
consider the following key capabilities:

1. It must be able to schedule jobs.
2. It should have built in managed file transfers.
3. Central, scalable and multi-tenant architecture.
4. Support object orientation to enable fast, flexible implementations.
5. Provide native application support.
6. Support dynamic, event-driven automation.
7. The ability to embed conditional business rules.
8. Support advanced workload balancing.
9. Provide a self-service capability to enable end-user involvement.
10. Enable security and compliance across the enterprise.

Whilst (??) there are many other factors that are also important to consider, only by ensuring
that your solution encompasses the above key capabilities as a foundation can you be
certain that you will be able to meet the ever increasing demands of the business.

Problem & Solution

AppWorx at a glance


AT A GLANCE: This infrastructure software solution now features a 100-percent Java* environment, enhanced Web services with XML support, a SOAP API, multidatabase support through JDBC and expanded multiplatform support, including the mainframe.

DETAILS: AppWorx is enterprise software that manages a company's application landscape from above. As a development tool, it can automate application batch processing routines without scripting. As an integration tool, it can integrate batch-processing requirements across multiple applications, speeding implementation. As an operations tool, it can perform data center "lights-out" processing, reducing headcount and lowering production and maintenance costs. As a business tool, it can ease the burden on functional end-users and accelerate the delivery of important business information.

http://www.ibmsystemsmag.com/mainframe/productnews/AppWorx-7/

Monday, November 24, 2014

What is Kuali Coeus?

What is Kuali: “Kuali is a growing community of universities, colleges, businesses, and other organizations that have partnered to build and sustain open-source software for higher education, by higher education. “ – kuali.org/about

What is Kuali Coeus: An open-source Electronic Research Administration system Originated in MIT as “Coeus,” it has been redeveloped using modern technologies by the Kuali Foundation.

Kuali Coeus meets many of the objectives and requirements identified by Boston University for an Enterprise Research Administration System. Kuali Coeus provides a comprehensive research proposal development and management system that integrates well with BU’s future financial system (SAP) and fits within the overall vision for a “cradle-to-grave” solution for research administration

Learn more about Boston University's implementation of a Kuali Coeus system here.

What is Oracle Pro*C ?

Here is a chapter from a book on Oracle 10 that describes Pro*C as Embedded SQL

http://tinman.cs.gsu.edu/~raj/books/oracle10-primer.html

The wikipedia page on Pro*C

http://en.wikipedia.org/wiki/Pro*C
 

Pro-C Tutorial with programming examples
 
http://programmingexamples.wikidot.com/pro-c-tutorial

There seems to be both a SAS PROC and an Oracle Pro*C that do the same thing.
Both are basically a means of embedding sql code in a c or c++ program.



Questions

How is embedded SQL different from just a stored procedure?
Why would you embed SQL scripts in a C program?
Is this useful for systems integration issues?
How does this relate to middleware or messaging?

What is appworx?


AppWorx is a web based java application used to schedule and run jobs against the Banner database.

User Guide
http://devwww.erp.ufl.edu/implementation/teams/it/51User.pdf

Appworx with Oracle EBS
https://community.oracle.com/thread/2518148?start=0&tstart=0


Appworx can interface with EBS and schedule/run concurrent programs.

http://www.oracle.com/us/partnerships/solutions/033668.pdf

Appworx is a scheduling tool that can automate scheduling of programs across the enterprise - it is especially useful in creating a sequence of jobs that need to be run on disparate systems in a specified order (i.e. run job 1 on the mainframe, then job 2 on EBS, then job 3 on another database etc). This job chain can be non-linear too (i.e. if job A runs successfully then run job B, else run job C etc). Concurrent manager of EBS is intended to run jobs only on the EBS instance - it inherently is unable to runjobs across the enterprise.

Sunday, November 9, 2014

What is WDSL?

The Web Services Description Language (WSDL) is an XML-based interface definition language that is used for describing the functionality offered by a web service.