Accessing MS Access database through datastage

nash · Post by **nash** » Wed Jan 23, 2008 2:04 pm

Is there a way to access data from a MS Access database in DataStage version 7.5 or more?

gateleys · Post by **gateleys** » Wed Jan 23, 2008 2:12 pm

nash wrote:Is there a way to access data from a MS Access database in DataStage version 7.5 or more?

Since you are on Unix, you will have to check for 3rd party tool for connectinto MS Access.

You may want to save the data in a .csv file.

If you could associate the access .mdb file to a SQL Server, then you could use the ODBC provided for SQL Server.

nash · Post by **nash** » Wed Jan 23, 2008 2:19 pm

gateleys wrote:
nash wrote:Is there a way to access data from a MS Access database in DataStage version 7.5 or more?
Since you are on Unix, you will have to check for 3rd party tool for connectinto MS Access.

You may want to save the data in a .csv file.

If you could associate the access .mdb file to a SQL Server, then you could use the ODBC provided for SQL Server.

Yes, I already knew we can alternatively access through a .csv file. But when I went through the available documentation there was nothing mentioned about MsAccess specifically even though they had mentioned about drivers for dBase , FoxPro, text files, etc.
As you have mentioned how do I associate a MSAccess database to a SQL sever

gateleys · Post by **gateleys** » Wed Jan 23, 2008 2:24 pm

nash wrote:As you have mentioned how do I associate a MSAccess database to a SQL sever

I am not sure exactly how it is done, although I have heard it being done. I would think it is a valid question for your DBA. Please do share with us if he/she has a solution.

nash · Post by **nash** » Wed Jan 23, 2008 2:28 pm

gateleys wrote:
nash wrote:As you have mentioned how do I associate a MSAccess database to a SQL sever
I am not sure exactly how it is done, although I have heard it being done. I would think it is a valid question for your DBA. Please do share with us if he/she has a solution.

I just browsed through the MSDN and found this link little useful

http://msdn2.microsoft.com/en-us/library/ms175866.aspx.

You can also go through this. Thanks for your help

gateleys · Post by **gateleys** » Wed Jan 23, 2008 2:29 pm

You can also check out OBDC drivers for Unix plaforms to connect to SQL Server from DataDirect -

http://www.datadirect.com/downloads/index.ssp#1

DSXchange

Accessing MS Access database through datastage

Accessing MS Access database through datastage

Re: Accessing MS Access database through datastage

Re: Accessing MS Access database through datastage

Re: Accessing MS Access database through datastage

Re: Accessing MS Access database through datastage

Re: Accessing MS Access database through datastage