Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik newbie - how to read from MonboDB

Hello,

full disclaimer: I'm completely new to Qlik.

I want to filter and read from MongoDB collections to visualize data in QlikView (Personal Edition).

I've seen that there is no native MongoDB support in QlikView.

I've seen that there is MongoDB Connector for QlikView - QVSource - The QlikView API Connector (Docs).

Also, there is the Expressor MongoDB DataScript Module at http://community.qlik.com/docs/DOC-4433/version/5

When would I want to use the Expressor Module vs. the Connector?

Are there any other options?

Thanks for your help!

Best,

Tom

4 Replies
jagan
MVP
MVP

Hi Thomas,

If you are using Expressor as ETL then you need to use Expressor Module, otherwise you can use Connector to fetch data from Mongo Database. 

Regards,

Jagan.

chrisbrain
Specialist II
Specialist II

Just a quick note to say that we have a brand new version of our QVSource MongoDB Connector for QlikView released today.

MongoDB Connector For QlikView - QVSource - The QlikView API Connector (Docs)

Not applicable
Author

Thanks Jagan,

pardon my ignorance - in which scenarios would I want to use Expressor as ET?

To explain a bit more what I want to achieve:

I have a cron job which requests JSON-data via HTTP from several analytics data sources, and stores them in Mongo.

Now I want to analyze the data from the different data sources in Qlik View.

Thanks,

Thomas

jagan
MVP
MVP

Hi,

Without Expressor also you can load the data to Qlikview, but some organizations will use ETL tools like Expressor, Informatica etc. for data transformations and other stuff.  If you are using Multiple reporting tools like Qlikview, BO, BI etc. then ETL tools are used to transform the data and this data is used in all the reporting tools.  If you are using only Qlikview then probably Expressor is not necessary, you can do the data transformation in Qlikview itself using script.

Regards,

Jagan.