Does DataStage support Excel and SQLServer?

nelc · Post by **nelc** » Mon Sep 29, 2003 2:28 am

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!

WoMaWil · Post by **WoMaWil** » Mon Sep 29, 2003 2:53 am

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

stan_taylor · Post by **stan_taylor** » Mon Sep 29, 2003 8:01 am

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

ray.wurlod · Post by **ray.wurlod** » Mon Sep 29, 2003 5:35 pm

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