Hi,
Just wondering that if i have to connect to cubes for example Oracle, Microsoft or Hyperion Essbase cubes how can i do it through datastage ? or is not possible is there a workaround?
Thanks.
Connectivity to Cubes ?
Moderators: chulett, rschirm, roy
Connectivity to Cubes ?
Teradata Certified Master V2R5
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is a Hyperion Pack available now...... I haven't seen or touched it yet, so can't give you details, but it may be worth looking into. For years though, directly writing to a cube wasn't in big demand because most of the cube vendors prefered defining and manipulating those things in their own tooling, so creating a clean .csv file or staging rdbms table with DataStage was enough.
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Yup, that's how I've had to do it in the past. As noted "they" didn't want anyone else writing directly to them so we had to leave the data on their doorstep and then ring the doorbell.eostic wrote:For years though, directly writing to a cube wasn't in big demand because most of the cube vendors prefered defining and manipulating those things in their own tooling, so creating a clean .csv file or staging rdbms table with DataStage was enough.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: