300 likes | 565 Views
Who is ASNA ? . ASNA (Amalgamated Software of North America, Inc.) has been developing visual programming for the midrange community since 1982. Has over 300,000 users and 27 international distributors. Product Offerings . ASNA Visual RPG (AVR) Windows programming language Acceler8DB
E N D
MagnaPalooza 2003 Who is ASNA ? • ASNA (Amalgamated Software of North America, Inc.) has been developing visual programming for the midrange community since 1982. • Has over 300,000 users and 27 international distributors.
MagnaPalooza 2003 Product Offerings • ASNA Visual RPG (AVR) • Windows programming language • Acceler8DB • Provides platform-transparent database access for Windows and Web applications for both the iSeries 400-AS/400 and Windows • DataGate/400 • Fast, record-level DB2/400 database access from Windows and the Web • AVR .NET – Replaces AVR
MagnaPalooza 2003 AVR Life Line • 1994 – AVR is rolled out • ASNA pioneered the first 16-bit version Windows-based integrated edit-compile-debug environment for the AS/400. • 1995 - ASNA released AVR 2.0 • with the debut of WIN95, AVR got the 32-bit boost it needed. • AVR 3.0 • works with any other Windows Common Object Model (COM)-compliant application (enabling AVR, for example, to tightly integrate the AS/400 with Microsoft Office).
MagnaPalooza 2003 AVR Life Line (con’t) • AVR 3.5 thru 4.0 • Not only works with all COM-compliant apps, it creates Microsoft COM objects (i.e. dll). This opens the door for Web and client/server applications. • AVR .Net (beta) – Partners with Microsoft • Utilizes Microsoft’s .Net platform allowing VB programmers (and programmers using most any other COM programming language) robust, secure and reliable read/write access to iSeries 400 - AS/400s, SQL Server 2000 and ASNA Acceler8DB databases.
MagnaPalooza 2003 Application Security • All AS/400 security is used in AVR applications. • If you are not authorized to a file, the program will not allow you to use it.
MagnaPalooza 2003 Magnatron uses AVR • PCN System • Tracks, prints and e-mails Customer PCNs and Quotes.
MagnaPalooza 2003 Magnatron Web Site • Support documentation page utilizes AVR to display data residing on the AS/400.
MagnaPalooza 2003 Does Magnatron and ASNA go together?
MagnaPalooza 2003 Web Order Entry/Tracking • Burco Services and Richmond Supply Co. have built on-line shopping carts accessing real time data on the AS/400 and generating Web Orders directly into Magnatron.
MagnaPalooza 2003 Burco Services / Richmond Supply Web pages
MagnaPalooza 2003 E-Mail / Web App • Burco Services sends e-mails to Vendors via an AVR program which provides a link to an AVR Web page allowing the Vendor to update their information.
MagnaPalooza 2003 Burco – Email / Web App
MagnaPalooza 2003 Check Reconciliation - Burco generates an ASCII text file of printed checks which is emailed to their bank. - A Cleared Checks ASCII file is emailed back and updated in Magnatron saving much time by not having to re-key this information in the ‘Cleared Checks Entry’ program.
MagnaPalooza 2003 Server/PC Applications • Pro Video Warehouse, Inc. has developed a Quick Order Entry system. • Create new Items in Magnatron • Creates Item Master, Item Detail, Item X-Ref records • Enter Order Form info into files on the AS/400 • * Since all data resides on AS/400, they are backed up nightly • Programmatically transfer to Excel spreadsheet • Generate Live Magnatron Orders • Print Order Confirmations
MagnaPalooza 2003 Pro Video – Media Order Form
MagnaPalooza 2003 Pro Video – AS/400 Data Read into Excel Spreadsheet
MagnaPalooza 2003 Pro Video – Order Entry
MagnaPalooza 2003 Pro Video – Quick Title Info
MagnaPalooza 2003 Pro Video – Order Confirmation
MagnaPalooza 2003 Pro Video – Create Magnatron Orders
MagnaPalooza 2003 What else can AVR can do for you? • AVR has the ability to: • Display and Print images (National Seating) • Display and Print graphs • Utilize 3rd party COM objects • (i.e Outlook, Excel, Verisign, etc.) • Anything your business needs
MagnaPalooza 2003 What are the requirements ? • Windows 98 or better. • Datagate/400 License from ASNA. • That’s it!
MagnaPalooza 2003 What people think about ASNA • ASNA DataGate provides fast, record-level access to the AS/400. I was able to quickly get my applications running in a client/server environment."Ralph Smith, RSI, Inc. • "We were impressed by the reliability and flexibility that ASNA Visual RPG offers. The speed of accessing the AS/400 is fantastic and the OCXs are a godsend."—Matt Blake, Choice Technologies • "ASNA Caviar has enabled us to extend applications in weeks that used to take us months to do using traditional RPG development."—Jacques Ohana, Midrange Software