I've never found UNIX drivers for Microsoft Excel or Access. I have however heard of accessing Access dbs on UNIX by going through the MySql database because it can get to a Windows Access db through ODBC. This link might provide a little more insight:
http://www.myfirsthosting.com/ms_access.htm
Search found 175 matches
- Mon Dec 23, 2002 1:01 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: MS Access ODBC Drivers for UNIX
- Replies: 1
- Views: 1327
- Sat Dec 21, 2002 4:03 pm
- Forum: Data Integration
- Topic: Normalized vs Denormalized
- Replies: 6
- Views: 6556
relational vs multidimensional olap
I have an anonymous wp that discusses when to use multidimenional or relational OLAP. This is probably a different slant than the original normalized vs. denormalized question, but thought it may be useful or could make the discussion more dynamic. Here is a paraphrase of when it says a multidimensi...
- Mon Oct 07, 2002 2:08 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage 6
- Replies: 4
- Views: 2219
There are a few new stages. A command stage that allows an OS or UV command to be run and can write to an output file. A Link Partitioner stage that is an active stage which takes one input and allows you to distribute partitioned rows to up to 64 output links. A Link Collector stage that is an acti...
- Sat Jun 22, 2002 2:55 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Reading Excel spreadsheets from DataStage
- Replies: 0
- Views: 1151
Reading Excel spreadsheets from DataStage
To read Excel from DataStage NT simply create an ODBC dsn to the file (tables will show up as system tables when importing metadata). Easy. Now onto reading a spreasheet from a UNIX DataStage server: Ideally, an ODBC dsn on the UNIX side would work, but is this even possible? If you know how to crea...
- Fri May 31, 2002 3:52 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: OLE DB
- Replies: 1
- Views: 852
That's the typical unmeaningful error message to expect from the OLE/DB stage. Sometimes there are multiple providers that can be used (if connecting to SQL server there is a SQL server provider, an ODBC provider, and a simple provider that can be used) that sometimes yield different or better error...
- Fri May 31, 2002 10:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hashed File
- Replies: 2
- Views: 1700
For some detailed info on hashed files go to http://www.fitzlong.com and click on support and technical papers. You'll find some white papers from the early 90s (but still valid) pertaining to hashed files. It is geared towards the UniVerse user and is probably more info than a DS developer needs to...
- Thu Feb 21, 2002 12:30 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle OCI problem
- Replies: 3
- Views: 2445
I'm wondering if maybe it's just an illusion that the query is taking that long but instead the job is performing another task before starting the query. One thing to check is if the job has another database stage that it's writing to and the update action is doing a clear of the table first. DataSt...
- Thu Feb 21, 2002 12:14 pm
- Forum: Site/Forum
- Topic: Search capability
- Replies: 3
- Views: 4541
There actually is a handy search tool, it's just easy to overlook. Underneath the Tools4DataStage heading on the top right there is a group of hyperlinks. In between Members and FAQ is Search, and this function lets you search for exact key word matches, any word matches, limit the search to a date ...
- Fri Feb 15, 2002 4:57 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: CompileAll tool
- Replies: 7
- Views: 2626
It's Friday afternoon, 5 minutes before 5PM....so I'm sitting here compiling my Version Control project with CompileAll and timing it. On a slow client and slow server I still was able to compile 243 jobs in 2:40. Additionally, those of you wanting to speed up compiling with this tool or just when d...
- Wed Jan 16, 2002 3:08 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Read performance from multivalued UV table
- Replies: 1
- Views: 1241
Read performance from multivalued UV table
I have some jobs that are reading an UniVerse tables with multivalued columns and load to SQL Server after the transformer breaks out multivalues into multiple columns. Displayed by the performance when having the ODBC stage set to 'Insert new or update existing' I changed it to 'Clear the table bef...