open

1
open
scalable
Consyst SQL presents
standard
independent
effective
The Smart Enterprise Suite
Presentation
2

• Canadian company founded in 1986
• Our goal create complementary productivity and
  management tools to optimize your investments in
• IDE (your languages and application servers)
• EAI (your ERPs, mainframes and legacy systems)
• EIP (your digital assets and contents)
• 150 person-years of investments in these three
  sectors!
• Our mission
• Solve the issues related to the global
  understanding and management of data in all
  systems of an organization. Specifically,
  Consysts solutions enable you to understand,
  control and integrate data utilization, ensure
  data integrity and optimize data processing.

Consyst SQL
3

• Some of our clients
• Teleglobe
• Département des Affaires municipales
• Reycan (Corus)
• Workers Compensation Board
• Ministère de lÉducation du Québec
• Air Transat
• Ministère du Revenu du Québec
• Société des Alcools du Québec
• Airbus / Aerospatiale (France)
• National Defence Canada
• Investissement Desjardins
• FjordTech Industrie
• Etc.

Consyst SQL
4

• Are you facing these challenges?
• How can I respect the need for autonomy of the
  communications staff without jeopardizing the
  technology orientations of my organization and
  without holding back the prerogatives of the
  computer specialists and systems architects?
• Is there an affordable, upgradable and open
  portal solution that will help me quickly enhance
  my information assets? (documents, presentations,
  booklets, Web contents, animations, etc.)
  Securely facilitate their management,
  classification, promotion and access?
• How can I formalize our in-house processes of
  creation, revision, approval, publication and
  distribution?
• Which portal environment will allow me to create
  an intranet or an extranet and integrate easily
  my current environments
• Collaboration (email, contacts, calendars, etc.)
• Enterprise environments (ERP, CRM, mainframe,
  etc.)
• Development platform and expertise (.NET, J2EE,
  etc.)

Consyst SQL
5

• We offer you
• To implement, progressively, with no risk and at
  an incredibly low price, a portal that meets your
  current business priorities and that ensures you
  the fastest ROI!
• A secure, flexible and scalable portal,
  independent from platforms, underlying
  technologies and DBMSs, that will support your
  growth, internal or external.
• A portal that integrates your desktop,
  collaborative, computer and technological
  environments so that you can promote all your
  digital assets and fully take advantage of all
  the benefits, real and potential!
• A rich set of features for the management,
  administration and organization of contents,
  documents, collaboration, security and
  customization.

Consyst SQL
6
Our family of products provides

• Interfaces and connectors for
• DBMSs (native drivers)
• Mainframe (Ims, IDMS, CICS, Cobol, etc.)
• ERPs, CRMs, etc.

• Portal features
• Content management system
• Integration to desktop applications
• Authentication and security
• Interface to groupwares (Outlook, Exchange,
  
  GroupWise, etc.)

• Productivity suite for application development
• .NET frameworks (C, Visual Basic) J2EE (Java)
• Dynamic repository for the management of metadata

7
Gartner Group predicts
By 2004, smart enterprise suites will emerge
as an aggregation of functionality offered today
by portals, team collaboration and content
management. They will replace portals and team
collaboration support products as the focus of
investment within a majority of enterprises
8
REPportal foundation
Our Solution
9
EIP
PORTAILS
CONTENU
IBM
MICROSOFT
ORACLE
ERP/CRM
IDE
BEA
EAI
Proprietary technology providers
10
EIP
PORTAILS
CONTENU
VITRIA
WEBMETHODS
ERP/CRM
IDE
SEEBEYOND
TIBCO
EAI
Pure-play Providers
11
EIP
PORTAILS
CONTENU
SIEBEL
SAP
PEOPLESOFT
ERP/CRM
IDE
J.D.EDWARD
EAI
Proprietary technology providers
12
EIP
PLUMTREE
DOCUMENTUM
PORTAILS
CONTENU
VIGNETTE
ERP/CRM
IDE
HUMMINGBIRD
EAI
Pure-play Providers
13
EIP
PORTAILS
CONTENU
Since back-end integration is a major selection
criterion for a portal application, one of the
biggest challenges for the pure-plays that are
willing to fight it out with the big fish is the
packaging of portal offerings with integration
servers. Portals Community
CONSYST SQL
ERP/CRM
IDE
EAI
Pure-play Providers
14

• Portal features
• Integration and management of roles and profiles
• Forum and collaboration tools
• Events calendar
• Contents and documents management
• Syndication and subscription
• Integration of desktop applications
• Work folders management
• Multilingual taxonomy
• Search function
• Process automation
• Email integration
• Customization
• Management console
• Archival features

Mainframe
Application server
DBMS
ERP
Repository
Some of the Features
15

• Three-tier, open architecture
• Windows et Web user interfaces
• Significant scalability
• Encryption and security using PKI (public key
  infrastructure)

Mainframe
Applicationservers

• Independent from DBMSs
• Access to DBMSs with native drivers
• Support for connection pooling

DBMSs
ERPs
Repository
Architecture
16

• Mainframe connector
• CICS/Cobol support

Mainframe
Applicationservers
DBMSs

• Bi-directional integration with ERPs
• SAP
• Oracle Financial
• Siebel
• PeopleSoft
• J.D. Edwards
• etc.

ERPs
Repository
Integration
17

• Support of main application servers
• Microsoft (COM et .NET)
• IBM (WebSphere)
• Oracle (JDeveloper)
• BEA (WebLogic)
• Sun (iPlanet)

Mainframe
Applicationservers
DBMSs

• Metadata, rules and parameters centralized and
  accessible through a neutral, open repository
• Federated database
• Declarative approach
• Easy and powerful adaptation
• 75 less programming
• Self-documented system

ERPs
Repository
Architecture
18
Our Solution
19

• Templates management
• Powerful template editors
• Templates bank
• News editors
• Menu generator
• Image manager
• Classification structure
• Process integration
• Automated publication
• Etc.

• WYSIWYG interfaces
• Contextual editors
• No training necessary
• Editing functions according to rights
• Contextual approval
• Automatic notification
• Systematic reuse
• Etc.

• Document management
• Office suite integration
• Multiple classifications
• Check-out of documents
• Planning of document archival
• Management of sites (location, etc.)
• Transactions log
• Version management
• Automated indexing
• Search tools
• Subscription
• Support of ODMA WEBDAV
• Etc.

Our Solution
20

• Groupware integration
• Exchange (Microsoft)
• Lotus (IBM)
• GroupWise (Novell)
• Etc.

• Application integration
• .NET integration
• J2EE integration
• Specialized connectors
• Mainframe
• SAP
• PeopleSoft
• Oracle Financial
• Siebel
• J.D. Edwards
• Etc.
• Native support of RDBMSs
• Forms generator
• Etc.

Hyperlinks management
Our Solution
21

• Groupware integration
• Exchange (Microsoft)
• Lotus (IBM)
• GroupWise (Novell)
• Etc.

Contacts management
Our Solution
22

• Portal Architecture
• Encryption, authentication using PKI
• Three-tier architecture
• Windows or Web user interfaces
• Independent from RDBMSs
• Specific connectors for
• ERPs
• Mainframe
• Application servers
• Roles management
• Integration to desktop applications

Architecture
23

• Services Offered
• Evaluation of your needs
• Adapted implementation plan
• Integration to your Web sites
• Training and complete documentation
• Support and onsite coaching
• Service of integration to your infrastructures
• Warranty, maintenance and updates services
• Resources available to help during implementation
• Acquisition and maintenance fees adapted to
• your architecture
• the number of users
• the features used

Services
24

• We Will Help You
• Analyze your needs and create a course of action
  that is well adapted, upgradable and without
  risks
• including a plan of implementation, migration
  and integration
• of your current Web site
• of your documents, contents and other digital
  assets
• of your digital forms
• of your computer systems and ERPs
• of your mainframe
• of your security and user profiles management
  system
• of your desktop and collaboration environments

Services
25

• Technical Benefits
• Flexibility, performance, robustness
• Product open to most languages, DBMSs,
  application servers, etc.
• Sources and parameters available as declarations
  and business rules, documented and centralized in
  the included inventory system
• Ease of integration with your technological
  environment
• Adaptation and upgradability, according to your
  current and future business needs
• Scalability
• HTML / XML / WML support
• Three-tier architecture (fat client and HTTP)
• Multi-site, multi-server support
• Large number of other portal features available
• Advanced technologies (languages, RDBMSs,
  interfaces)

Benefits
26

Business rules- driven application
development tool
Complementary Solutions
27
Contact us!

• For all your portal requirements,
• we have the solution that you need.
• Contact us, or attend our free seminars!
• pierre.fournier_at_consyst-sql.com
• [phone]

Thank you !