Page 1 of 1
Does DataStage support Excel and SQLServer?
Posted: Mon Sep 29, 2003 2:28 am
by nelc
Hi all,
I am currently using DataStage version 5.
Just like to check whether the newer versions support MS Excel and SQL Server?
Thanks in advance!
Posted: Mon Sep 29, 2003 2:53 am
by WoMaWil
Yes it does.
But I suppose you want also know the HowTo.
Excel on a Windows-Server via ODBC on a Unix-Server "Save to csv" and read with seq-Stage.
Wolfgang Huerter
=====================
Cologne, Germany
Posted: Mon Sep 29, 2003 8:01 am
by stan_taylor
SQL Server can be read via ODBC once you have configured ODBC correctly to access it from your DataStage server. If you are on UNIX or want to have a consistent way to access Excel and have the Java pack you can use POI (
http://jakarta.apache.org/poi/) to access the files directly.
Stan
Posted: Mon Sep 29, 2003 5:35 pm
by ray.wurlod
Note that the ODBC driver for Excel regards worksheets as system tables. [:0] This means:
(a) you must check "system tables" when importing metadata
(b) the "table names" come in prefixed by "$"
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518