Software markets are turning towards software as a servic

1

• Satellite Forces International Inc.
• Implementing a Corporate Services Network Using
• PostgreSQL,
• Linux and
• Open Source

2
Strategic Assumptions

• The strategy for Satellite Forces / Atlantis for
  this year (2007) will be based on the following
  assumptions
• Software markets are turning towards software as
  a service (SaaS)
• Open Source is becoming a market force that will
  influence IT buyers
• Linux has reached maturity as a product and is
  acceptable as a solution
• Large amounts of cheap IT Labour is available
  from global on line services
• Business networks will be the future income
  earners
• Web based content management needs a mature
  customer oriented solution

3
apcs.homelinux.com

• PostgreSQL
• Atlantis Process Control System (APCS)
• Linux Router

4
Why use PostgreSQL?

• Satellite Forces selects PostgreSQL as the
  primary database solution for Atlantis.
• Migration to PostgreSQL is easy with Atlantis
• We know that our customers will need a migration
  solution that will allow the easy movement from
  one database to another.
• Atlantis technology is ODBC compliant and comes
  with a simple migration tool for converting from
  one data model to another. In addition, our
  migration tool can be used to automatically
  create business process and generate new software
  solutions.
• In addition, the new Atlantis Developers Kit
  (ADK) Open Source project provides integration
  solutions and a forum for developers.
• For organizations that are stuck on legacy
  solutions this is a convenient and effective way
  forward.
• Impressive array of features as compared with
  SQL Server, Oracle and MySQL
• Runs on Windows, Linux, Unix, Novel Netware and
  OS/2
• Runs on a workstation or laptop sized machine
• Comes with support for professional development
  and administration tools
• Visual Case and Data Architect
• PG Admin III
• Reporting interfaces for Crystal Reports, Cognos
  ReportNet and Jasper Reports
• Programming support for C , C , JDBC, Perl,
  PHP, Python, Ruby, Tcl and Visualworks Smalltalk

5
Why use PostgreSQL?

• Open source technical support includes
• almost 1,450 pages of detailed documentation
  regarding every aspect of the database
• online documentation is available for downloading
  in PDF format.
• newsgroups accessible through Google groups, with
  topics ranging across performance,
  administration, SQL construction, development and
  general matters
• hundreds of IRC support channels
• formal PostgreSQL support packages are available
  from commercial vendors such as CommandPrompt
  Inc.
• SQL standards-compliant database
• Preferred RDBMS for large scale web applications
• Designed for higher volume environments
• Open Source
• Free / No license costs

6
Why use a Linux Router?

• Routers are amongst the most crucial components
  of the Internet, as each bit of information on
  the Internet passes through many routers. Most of
  the routers used on the Internet are made by
  Cisco. Although these have good performance, they
  come at a high price.
• The performance of the Linux router makes it an
  attractive alternative when concerned with
  economizing.
• When used as a simple gateway for a LAN, a Linux
  router can be almost free. All that is needed is
  an old 486DX machine with more than one network
  interface.
• A monitor is not always necessary. If used for a
  sophisticated application you will need a Pentium
  PI 200MHz MMX, which costs more but is still
  three or four times cheaper than a commercial
  router with comparable functionality.
• Ref http//www.linuxjournal.com/article/5826

7
APCS Linux Router Overview

• APCS Linux Router benefits
• Large number of features available in software
• Unlimited port routing
• Extensive firewall features
• Traffic shaping
• Supports services model
• The PC-based model means faster performance
• Easy to update
• Hardware
• PC Based
• 256MB RAM, DUAL Network Interface
• Software
• Ubuntu Linux http//www.ubuntu.com
• Quicktables http//qtables.radom.org
• Optional IP Cop http//www.ipcop.org

8
APCS Linux Router Setup

• Install your dual network cards
• Configure Card1 for LAN (suggest 192.168.0.100)
• Configure Card2 for WAN (use modem or WAN IP)
• Install and run quicktables
• Quicktables will ask you to
• Define which port mappings you will allow
• Firewall allow / deny settings
• Quicktables generates a script which you can run
  as root once. This will turn everything on.
• Connect your home or business network to Card1
  and set it's gateway to 192.168.0.100
• Optional PostgreSQL, Apache and APCS Software
• Run your home or business network normally

9
apcs.homelinux.com

• apcs.homelinux.com
• Port services
• 21 FTP
• 81 Apache
• 5432 PostgreSQL
• 7000 Sandbox APCS
• 7003 SC Network
• Reference Linux Journal

10
APCS Software

• Runs on port 7000 to 7010 of apcs.homelinux.com
  as a service
• Controls access to PostgreSQL
• Business example APCS controls user access to
  sales leads, contracts and software projects for
  Savant Connect.
• (http//savantconnect.com)
• Currently manages multiple IT projects
  simultaneously with clients and vendors
• For details, checkout ADK at http//adk.sourceforg
  e.net

11
APCS Sample Session
12
Future

• Wider array of applications work with PostgreSQL
• ADK enters IBM Partnerworld
• Open Atlantis portal to PostgreSQL
• DB2 Database Support
• IBM Linux Packaging and Testing
• Watch for details on satelliteforces.ca
• Checkout or even join the Open Source project at
  http//adk.sourceforge.net

13
For More Information

• We update our website daily
• http//satelliteforces.ca
• office_at_satelliteforces.ca
• David Long, CEO [phone]
• Check out adk.sourceforge.net