Transcript 2-APCSPresentation2007

Satellite Forces International Inc.
Implementing a Corporate
Services Network Using:
PostgreSQL,
Linux and
Open Source
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
apcs.homelinux.com
PostgreSQL
+
Atlantis Process Control System (APCS)
+
Linux Router
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
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
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
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
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
apcs.homelinux.com
apcs.homelinux.com
●
Port services
 21 FTP
 81 – Apache
 5432 – PostgreSQL
 7000 – Sandbox APCS
 7003 – SC Network
Reference: Linux Journal
●
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.sourceforge.net
APCS Sample Session
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
For More Information
We update our website daily:
http://satelliteforces.ca
[email protected]
David Long, CEO – (613) 796 3048
Check out adk.sourceforge.net