topic Re: Sage Evolution 7 and OLE DB help for a newbie in QlikView

Sage Evolution 7 and OLE DB help for a newbie

Mon, 22 Jun 2015 14:26:58 GMT

Hello everyone,

My head exploded when I tried to build a report after connecting to Sage to build some reports. There are so many tables with strange names, which left me more clueless (I am very new to QV) .

Is there anyone that has done this before that would mind sharing some insight of some type?

Below is an example of the tale types - where to start?

Re: Sage Evolution 7 and OLE DB help for a newbie

oknotsen — Mon, 22 Jun 2015 16:48:30 GMT

First stop would probably be the supplier of the database / program that uses the database and (I know, sounds naïve) ask them for an explanation of their data model. Next stop would be the documentation of the software/database (and complain to the supplier of the software if this is not available).

Now the above probably will take some time and might not give you much to work with. So alternatively I would look for a copy of that database with (limited) test data and bluntly start loading tables into QlikView. With a little bit of luck this will give you an idea of how the different tables are connected. Since you might get a lot of syn. keys, be sure to switch to "Source table view".

That should get you a few steps into the right direction.

Re: Sage Evolution 7 and OLE DB help for a newbie

Thu, 25 Jun 2015 13:32:40 GMT

Hi there,

Thanks for taking time to answer.

I'll try this so long