Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

FileMaker Pro data in QlikView anyone?

Has anyone utilized QlikView to analyze FileMaker Pro data?

Thanks!

4 Replies
Highlighted
Contributor
Contributor

FileMaker Pro data in QlikView anyone?

Yes we did.

It was difficult to get the ODBC to work :

* I took a backup of the filemaker DB

* opened it onto a local installation of FM10 (Of course FM10 configured to allow access to this DB via ODBC)

* then opened Qlikview and used the ODBC wizards to load data

* when running the script, all things stall for a very long time (in my case the timer stalls on Elapsed 00:00:01 for about 10 minutes), because the filemaker ODBC takes a very long time to process the query...

* so I figured out to speed things up by not importing all the fields, but only the ones really needed.

I didn't really manage to automate this 😞

remark : FM10 and FM11 have a different ODBC driver, and the are not compatible -> install the correct on.

Highlighted
Not applicable

FileMaker Pro data in QlikView anyone?

Thanks for the information!

Were you able to gain any insights into data using QlikView?

Tyler

Highlighted
Contributor
Contributor

FileMaker Pro data in QlikView anyone?

clearly once we got the data into qlikview, it was easy to get all kinds of usefull stuff out of it.

Especially I could demonstrate how 'dirty' the data actually was/is.

BTW, another way to go from FileMaker to Qlikview is to export the tables in FM as excel. This works faster for me. As the ODBC couldn't be automated, in the end this excel export is as good as a manual ODBC import.

Bye

Highlighted
Not applicable

FileMaker Pro data in QlikView anyone?

Thanks again for the tips!