Loading the Data from Sybase/Heperion Datasources

[#1]

Guys,

Do you have any Experience in Loaing the data from Sybase/Hyperion Datasources. If yes please share your experiences.

If you can share examples that will good for me in quick understanding.

Thanks,

Ram.

[#2]

Any ideas to share?

[#3]

Regarding Hyperion, No, as it is cubes, I'm not sure we can load data directly from there.

Re Sybase, yep it is owrking really fine, using SQL Select and executing stored procedures. I accessed Sybase using ODBC and OLEDB.

If you need more help on ASE Sybase , feel free to ask.

Rgds,

Sébastien

[#4]

hi Pastor,

I have odbc connection to xyz_db set up in my local machine. I can connect and view the data.

My problem is that, now I have to migrate this same qv file to a server, a different machine, which

does not have the xyz_db set up.

ODBC CONNECT TO xyz_db (XUserId is asdsdasdas, XPassword is dfswfsdfsdfsd);

Test:
select abc, def from table where abc is not null;

My question is whether we can have give the connection details directly instead of the xyz_db, ie, something like

ODBC CONNECT TO sg12343.sppp.com,2500 (XUserId is asdsdasdas, XPassword is dfswfsdfsdfsd);

Ram, u need to got to control panel=>administrative tools=>Data Source=>double click=>Add==> choose Adaptive Server Enterprice==>fill in the required details.After this the new data source will show up when u goto edit script==>Connect.