Satellite Forces International Inc. Implementing a Corporate Services Network Using: PostgreSQL,

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.sourceforge.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@satelliteforces.ca David Long, CEO – (613) 796 3048 Check out adk.sourceforge.net