Home > IT Answers > AS/400 > As 400 database linking to the website
Dumieprince
5 pts.
 As 400 database linking to the website
AS/400 Administrator, AS/400 DATABASES, AS/400 FUNCTIONS
Hi I want to link the account enquiry option on the AS 400 to the company website so that users can make account enquiries on the site. my question is how can I link the two?

Software/Hardware used:
IBM AS400, SERVER and LINUX
ASKED: November 29, 2011  8:18 AM
UPDATED: March 17, 2012  6:41 AM
RELATED QUESTIONS
Answer Wiki:
I agree with Yorkshireman's recommendation to deliver the information via an "intermediate mechanism." We needed to do exactly what you describe and settled on DataGate from ASNA as our intermediate mechanism. This tool is designed for the iSeries which means in integrates seamlessly with DB2.
Last Wiki Answer Submitted:  November 29, 2011  4:34 pm  by  WoodEngineer   5,525 pts.
All Answer Wiki Contributors:  WoodEngineer   5,525 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Exactly *what* do you need to protect?

Does your site prompt for an account number, or are you proposing to allow anyone to browse the account file?

The first thought is to insulate the site from DB2 by delivering the information via an intermediate mechnism – the site calls a service, delivering an account number – the service accesses the DB2, and delivers an appropriate amount of data. Ensure no possibility of access to more than 1 account.

Presumably you have stringent authorisation of the site user before than get to this point?

.

Yorkshireman
 5,505 pts.
 

…without exposing the system to hackers?

Without exposing what system?

…to the company website…

That usually implies that the “company website” is already ‘exposed’. Is that a more secureable system than your AS/400? (Why do you think so?)

Can your users’ PCs already access the company website? If so, then what exactly is the concern?

Tom

TomLiotta
 107,985 pts.
 

my question is how can I link the two?

How do you want to link them? What do you want to happen?

If you choose to do so, your AS/400 programming can make the inquiry and present any returned data for your users.

But that doesn’t seem to be what you are after. Please describe the need more fully.

Tom

TomLiotta
 107,985 pts.