Can Bex be used as a standalone app and connect through ODBC ?

[Former Member]

Hi Guru's

We have a scenario in which we want to connect a Netezza server to our Netweaver2004s BW server and transfer the date from BW to Netezza .We want the queries to be processed by the Netezza server and view reports by placing Bex on top of Netezza server . My question is can we connect Bex to Netezza server by using ODBC and not the odbc of the excel ..or is the connection needs to be made through the ODBC of excel and Bex will work fine as it is embedded in excel itself . Any pointers in this regard will be of great help .

Thanks in advance

Ankush

[Former Member]

hi we have used VC instead