The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Linking SalesLogix to QlikView
Posted: 22 Aug 07 10:33 AM
|
Hi all,
Hopefully you can shed some light on this, I desparately want to be able to link SalesLogix data to that in QlikView using AccountID link etc. I've been looking at the DOM within VBScript for QlikView but cannot figure it out at present, I just keep getting a failure to open document message.
Can anyone shed some light on this, I just want a simply script that will open a document and set a parameter to filter the data on.
Cheers
Kevin |
|
|
|
Re: Linking SalesLogix to QlikView
Posted: 23 Aug 07 5:42 AM
|
Sage has a product called Visual Analyzer that sounds like what you are looking for. It gives you a mainview with an OCX container that gives you a Qlikview runtime inside SLX.
The linking of "external" (i.e. non SLX data) is something that you do via the load script in the QVW file. It's mostly just making sure that your external data has an ACCOUNTID field. (Make sure to match case on the variable name -- it matters).
If you have not done much with Qlikview, there are some definite gotchas that you need to be careful about. It auto-joins based on your fieldnames, so you have to be VERY careful about what you call things so you don't wind up with a cross connected mess.
Hope I did not answer the wrong question here 
ws |
|
|
|
Re: Linking SalesLogix to QlikView
Posted: 28 Aug 07 7:34 AM
|
| Ah was looking for more of a VB solution as there seems to be the functionality there with the QlikView DOM, I just can't configure it and need examples. |
|
|
|
Re: Linking SalesLogix to QlikView
Posted: 29 Aug 07 4:41 AM
|
Your best bet is probably to join Qlikview QlikCommunity
http://www.qlikcommunity.com/
I have not done much with version 8 (Visual Analyzer is built on 7.52), but I know that they were really beefing up the integration capabilities.
I know that I've seen some documentation on integrating QV, but I can't seem to find it right now. (It may just be on my old laptop).
If I find it I'll ping you. Otherwise - I think QlikCommunity is your best bet.
ws |
|
|
|