AIX and SQL Server

Hi,

I have a question and want to know whats the best way to implement this initerface.

We have a need where we need to connect to SQL server to pull the data and map this data as HL7 (which is ok) and send the HL7 messages to the outbound system.

Should it be easy to use a TCL/Shell script to connect from AIX to SQL server and pull the data into a file and then process the file?

If so, what are the steps that I need to take to achieve this. All systems within the network. so no firewall issues I guess.

Does anyone have a script that I could use to test both the connectivity and pulling data from SQL server tables? Will AIX use a lot of resources to execute this script?

Appreciate any help with this.

Thanks,

HK