Best way to get data into MySQL DB

P

Paul O' Connor

New Member
Hi,

I am playing about with getting data from our Progress DB online. I have experience with MySQL/PHP and am thinking of using that platform for exposing our data online. Just wondering if anyone has played about with transferring data from a Progress DB to MySQL?

I have a couple of possible methodologies
1. Build a web service which I can have my Progress app connect to to upload data
2. Export data from Progress to XML and have a cron job use PHP to insert to MySQL

Just wondering if anyone has experience of doing something similar and what methodology they used.

Thanks,
Paul
 
Cringer said:
Is this a one-off exercise, or are you trying to get a replica in MySQL?
Click to expand...

This would be an ongoing process. I am looking to upload records to MySQL once a day. The data will be viewed on the web (i.e. no update by end-users) so it's effectively an online reporting facility.
 
I've never done anything like this myself, but why not use OE Replication to create a read only replica of your DB and use something such as ODBC to connect with SQL? My initial thoughts on what you are trying to do is that it is a lot of work (and risk) for something that you could solve using things that are already available.
 
Why do you imagine that you must get the data to MySQL in order to expose it online? Progress is perfectly capable of serving data to the web.
 
TomBascom said:
Why do you imagine that you must get the data to MySQL in order to expose it online? Progress is perfectly capable of serving data to the web.
Click to expand...

Hi Tom,

I suppose it is borne out of lack of familiarity with what Progress offers and familiarity with PHP/MySQL. I've only ever used Progress for developing business applications whereas any web-based work I've done has been via MySQL/PHP. Might well be a case of picking a solution to match my skills as opposed to picking a solution to match the problem!
 
I'm probably guilty of the same thing.

But I don't see any value in moving the data from one db to another just to use a more familiar tool.
 
Just to follow up on that, what do people recommend as the best methodology of putting data from a Progress DB online? I've not kept up to speed with the various solutions offered by Progress (I believe things have moved on since WebSpeed).
 
IMO Webspeed is still an excellent solution so long as it is coded correctly.
We are working on a project at the moment (I'm not involved so I don't know the details) where we are creating and API to expose parts of the system to C# code. This will then be available online to certain customers. It's pretty impressive what they've achieved so far! :)
 
Webspeed is great if you need an application.

The SOAP and REST adapters are what you probably want to pursue if you just need to feed data to an external application.
 
You must log in or register to reply here.
Back
Top