Question MS SQL Dataserver or HL7 to Progress Database Connection

Hi to All,

Just want to ask how can we connect the MS SQL Database to Progress Database? currently our data will be from SAP > SQL or HL7 > Progress can you advice me what to do?

our vendor told the there are 2 ways that they can supply the data
1. SQL Database
2. HL7

do you think which is the best ?

Thanks

There is a SQL DataServer product for Progress. We use it to push information into a SQL database. Unfortunately I'm not sure how it works! Sorry.

thanks Cringer maybe i'll wait for the others

As far as I understand your requirement is to store data from an application that only talks SQL ( never heard of HL7 ) into a Progress database. Usually such an application would support either ODBC or JDBC - for both of which Progress offers drivers. This way this application could connect the Progress database like any other of these SQL database - but the devil might be in the details.

• You would use a DataServer product from Progress when you need an ABL application use a SQL database.
• You would use the Progress ODBC/JDBC driver when you need a non-ABL application that supports SQL use a Progress database.

Both of which have their gotchas. But, depending on your requirement both of which can make you happy.

Heavy Regards, RealHeavyDude.