If my DataStage Server is on Unix Box,
is there a way DataStage can communicate with SQLServer Database.
Is it necessary to have the DataStage Server on Windows(only),
if we are loading data into SQLServer database?
Thanks in Advance.
General DataStage Server Question
Moderators: chulett, rschirm, roy
Sure, DS ships with an ODBC driver to SQL-Server 7. You just configure the odbc.ini file with the entries to point to each SQL-Server. It will require things like IP or hostname, db name, port, etc.
No problems doing what you want, as long as you have the right version and configuration information.
No problems doing what you want, as long as you have the right version and configuration information.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
kcbland wrote:Sure, DS ships with an ODBC driver to SQL-Server 7. You just configure the odbc.ini file with the entries to point to each SQL-Server. It will require things like IP or hostname, db name, port, etc.
No problems doing what you want, as long as you have the right version and configuration information.
Thanks for the Info, Ken