topic Loading the Data from Sybase/Heperion Datasources in QlikView

Loading the Data from Sybase/Heperion Datasources

Wed, 11 Nov 2009 17:44:29 GMT

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.

Loading the Data from Sybase/Heperion Datasources

Fri, 13 Nov 2009 16:30:20 GMT

Any ideas to share?

Loading the Data from Sybase/Heperion Datasources

Fri, 13 Nov 2009 18:43:14 GMT

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

Loading the Data from Sybase/Heperion Datasources

Fri, 27 Jan 2012 02:59:22 GMT

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.