Originally posted by: jvanboga

6.7.1

I have a .dat file that our user is opening in MS Access, then exporting to a flat file. I assume that because it opens in Access which recognises tables and data formats, without any xtra effort, I should be able to use the DBID to build both table an query type trees. This file is send from an external TP and I cannot get the data in any other format than received.

Anyone have experience with this? What ODBC drivers need to be used etc?

Looking for direction/feedback.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: repanzer

If the data is in an Access table and you have access to that table, yes, you can use the DBID. The ODBC will be for Access (one of them, with the *.mdb). Set it up on the odbc/system dsn side. I think you can leave the log in info blank if no security is set up.

This has nothing to do with Access opening up a ".dat" file. Do all ".dat" files open good in Access on that box? Create a quick text file, give it a dat exentsion and try opening it. Technically, it shouldn't. Users set which apps open file with which extension on Window's machines.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: jvanboga

Resolved.

FYI: I opened the dat file in Access, saved it as an mdb access file, built my type tree using the Access ODBC and TX DBID. I deleted the mdb file, moved a fresh '.dat' file over and vavoom, within 15 minutes (7.5 of that was map runtime) had the data extracted data and loaded to our oracle tables..... the only thing left is to test the load with the maptool executing sqlldr.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender