AIX and SQL Server

[hari nagasamudra]

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

Topic

[Jim Kosloskey]

You will need ODBC or JDBC to pull this off.

Healthvision sells a Cloverleaf(R) add-on for ODBC.

If you know Java you can use Java in the UPoCs.

There may also be a Tcl-ODBC or Tcl/Sql functionality but I have no experience with these if they exist.

Jim Kosloskey

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Author]

Replies