DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
DOS
Participant



Joined: 09 Jun 2006
Posts: 3

Points: 23

Post Posted: Fri Jul 12, 2019 9:34 am Reply with quote    Back to top    

DataStage® Release: 9x
Job Type: Server
OS: Windows
Additional info: ADABAS 6.1 in AIX
Hi all.
I have to access an ADABAS Database (in UNIX) from DataStage ... Is there a specific stage to do that? Is there an ODBC or JDBC driver that allows a Stage to access ADABAS directly, without having to copy them to a flat file and transfer them? Is there a specific driver for what I propose?
Thanks in advance.
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42998
Location: Denver, CO
Points: 221842

Post Posted: Sat Jul 13, 2019 4:20 pm Reply with quote    Back to top    

A bit old but this makes it seem ODBC is an option, since you have it UNIX rather than a mainframe. And I would imagine their product page would list the various options available to access that database.

_________________
-craig

I swore that I would love you to the end of time, so now I'm praying for the end of time to hurry up and arrive
'Cause if I gotta spend another minute with you I don't think that I can really survive
Rate this response:  
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42998
Location: Denver, CO
Points: 221842

Post Posted: Sun Jul 14, 2019 8:22 am Reply with quote    Back to top    

Via a private message:

DOS wrote:
Thanks chulett. I had already seen this old post, I wanted to know if there would be any other option besides the "NatQuery". Thanks again.

First off, please reply here rather than privately so other folks can know what's going on and help. Secondly, since you didn't mention any of that I went off searching and posted what I found.

As to the rest of my reply, IMHO your two best options for targeted help are (as noted) the maker of the product itself and IBM support as there may not be many ADABAS users here to wander by and see your post. If you scroll down on the ADABAS product page you'll see a "EASILY CONNECT TO ANALYTICS PLATFORMS" section which lists various ways to access it. I also see if you scroll ALL the way down that they have a forum where you could ask this same question with possibly speedier results.

Good luck.

_________________
-craig

I swore that I would love you to the end of time, so now I'm praying for the end of time to hurry up and arrive
'Cause if I gotta spend another minute with you I don't think that I can really survive
Rate this response:  
Not yet rated
DOS
Participant



Joined: 09 Jun 2006
Posts: 3

Points: 23

Post Posted: Sun Jul 14, 2019 8:53 am Reply with quote    Back to top    

Thanks again for the help, and apologize for my misunderstanding.
Regards.
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42998
Location: Denver, CO
Points: 221842

Post Posted: Sun Jul 14, 2019 9:04 am Reply with quote    Back to top    

No worries. Please come back and post whatever resolution you find!

_________________
-craig

I swore that I would love you to the end of time, so now I'm praying for the end of time to hurry up and arrive
'Cause if I gotta spend another minute with you I don't think that I can really survive
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours