homepage Welcome to WebmasterWorld Guest from 54.205.207.53
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Getting DB2/AS400 Data to Mysql
db2 / as400 to mysql
Monksp

10+ Year Member



 
Msg#: 424 posted 3:19 pm on Mar 29, 2006 (gmt 0)

Lets cut right to the chase…I am trying to collect data from a DB2/AS400 machine and put it into a mysql database. We are then going to display this information to our users on our site that is running the LAMP (linux apache mysql php) configuration. The data housed on the AS400 is behind our corporate firewall, so without a VPN we can not access the data from our site. So I thought I would attempt some type of sync from the AS400 out the firewall to the webserver.

Currently, I using the iseries odbc drive to import the data into mysql and it seems to be taking about two hours to get the data I need. Not at all a good way to show live data.

I am wondering, what is the best way to accomplish the connection?
Is there a better configuration for the iseries driver?
Is there a better driver to use.
What is the best way to give web users live data from a server that is inside a firewall?

 

txbakers

WebmasterWorld Senior Member txbakers us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 424 posted 3:41 pm on Mar 29, 2006 (gmt 0)

If it's behind your firewall you might have trouble doing this, but I was able to bypass mySQL entirely and connect directly to the AS/400 through the ODBC connection.

At one time i even considered using the AS/400 as my DB, given it's incredible stability and security.

As to dump it into mySQL, I don't see a good way to keep the sync close to real time. The iSeries ODBC driver is notoriously slow.

coopster

WebmasterWorld Administrator coopster us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 424 posted 4:43 pm on Mar 29, 2006 (gmt 0)


The iSeries ODBC driver is notoriously slow.

Which one? Windows? Because on *nix installations I have successfully implemented iSeries Access for Linux on a few different sites with blazing fast performance. Huge sites too, front and back end (intranet/internet) activity is enormous. I would agree that the iSeries Access for Windows is different though. I've had some success but nowhere near the speeds of the *nix installs.

As far as the entire install goes, why not put the server on the LAN and use your router to allow access to the DMZ host on the http server for the public IP?

Monksp

10+ Year Member



 
Msg#: 424 posted 4:58 pm on Mar 29, 2006 (gmt 0)

Coopster,

I am using the windows iseries driver with a navicat interface to import the data. I do have a few Linux machines and if you say it is fast then I need to look into the iSeries Access for Linux.

As far as putting the machine on the LAN … That is probably not an option at this time plus it is a bit over my head as far as setup. Not that I am not interested in investigating. With our IT, anytime you mix public access with Lan access, they would rather say NO than to invistigate.

If possible, do you have any additional info on the linux version of the iseries?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved