Hi,
Can somebody tell me how to import access database containing 17 tables into datastage.will metastage will be more useful.kindly tell me the whole procedure as i donno which dsn to use for access database.
thanx
importing access database
Moderators: chulett, rschirm, roy
I don't know of an MS-Access ODBC driver for Unix. One method is to use a SQL-Server database and connect the MS-Access mdb to it, then use the SQL-Server ODBC driver for Unix.
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
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
I also need to access to Ms access from Datastage PX ( 7.5.1A) in Unix ( IBM AX 5.3), if using intermediate DB ( Ms SQL server ) is the only feasible solution, how can I implement it, I mean can you be a little more specific about connecting Ms Access through SQL server so that I can use an ODBC stage in Datstage to access that SQL server.kcbland wrote:I don't know of an MS-Access ODBC driver for Unix. One method is to use a SQL-Server database and connect the MS-Access mdb to it, then use the SQL-Server ODBC driver for Unix.
Thanks,
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"