topic Re: Changing connection from SQL Server to SAP BW in QlikView

Changing connection from SQL Server to SAP BW

Mon, 16 Jul 2012 16:19:11 GMT

Good afternoon,

I'm working on a mobile project where I have developed dashboards in credit analysis area on top of SQL server. Now I would like to see how these dashboards are looking based on production data where SAP BW is used.

What's the impact of changing my connection from SQL Server to SAP BW? Do I need to do additional development?

Thanks in advance.

Onur

Re: Changing connection from SQL Server to SAP BW

rbecher — Mon, 16 Jul 2012 22:00:05 GMT

Hi Onur,

you will need the QlikView SAP Connector. Which is available as a licensed option..

- Ralf

Re: Changing connection from SQL Server to SAP BW

Tue, 17 Jul 2012 09:56:08 GMT

After changing the connection to QlikView SAP Connector, Do I need to do any additional development/adjustment in Dashboards/ Reports?

Re: Changing connection from SQL Server to SAP BW

rbecher — Tue, 17 Jul 2012 10:00:15 GMT

You probaly will have to change the load script. I guess the data model is fully different..

Re: Changing connection from SQL Server to SAP BW

Tue, 17 Jul 2012 13:49:54 GMT

So that means that I'll need to recreate the dashboars aswell. I'm a newbie so long explanation will really be appreciated.

Thanks in advance!!

Re: Changing connection from SQL Server to SAP BW

rbecher — Tue, 17 Jul 2012 13:58:51 GMT

It depends. You could consider the QlikView tables (from your existing dashboard) as an abstract business layer where you could fill in the data from a different source, if it fits to the given structure (tables) and granularity (level of detail).