Mongo Report

1

Hello, In jaspersoft server I have created a new data source connecting to a mongo database however when i am trying to create a domain it does not list the datasource so i can create a domain.

Am i missing soemthing ?

 

Thanks

oakrami's picture
30
Joined: Nov 1 2013 - 4:05am
Last seen: 5 years 3 months ago

2 Answers:

0

Hello,

Jaspersoft support for MongoDB uses a custom data source. Domains do not work with custom data sources.

However, as for 5.6 release you can use VDS (Virtual Data Source) to create domains. For that, you need to:

  1. Create a MongoDB Data Source (make sure you also include schema DDL in the Schema field. Sample below)
  2. Create a VDS Data Source, use the MongoDB DS you've created before.
  3. Create a domain using the VDS data source.

 

The Schema DDL is important, and you may run into issues if not properly defined. So before creating the MongoDB Data Source make sure you've mapped your MongoDB collection/documment to a SQL DDL, as the one below which uses MongoDB Zips dataset.

CREATE FOREIGN TABLE zips (
id integer PRIMARY KEY,
city varchar(255),
population integer,
state varchar(128)
) OPTIONS(UPDATABLE 'TRUE');
 
 
CREATE FOREIGN TABLE location (
id integer PRIMARY KEY,
latitude varchar(64),
longitude varchar(64),
FOREIGN KEY (id) REFERENCES zips (id)
) OPTIONS (UPDATABLE 'TRUE', "teiid_mongo:MERGE" 'Zips');
rudygodoy's picture
378
Joined: Nov 24 2012 - 3:52pm
Last seen: 3 years 11 months ago
-1

Hi there - 

If you created and successfully tested the data source, then it should be available from the pop up where you browse the repository when initalizing the Domain file.  You might want to double-check the save location.  It should be listed in the pop up.  Are you getting an error of any sort?  

Let us know. 

H Mendoza's picture
351
Joined: Feb 20 2013 - 11:39am
Last seen: 1 month 5 days ago

Hello, thank you for your reply.

No I am not getting an error but the data source is not available. I did check the save location.
Thanks

oakrami - 5 years 6 months ago

Hello, I am having the same problem as described by other user. I have created a new data source, tested successfully the connection to a Mongo DB however when I am trying to create a Domain or a Topic it does not list the Mongo DB datasource I created so I cannot progress.

Am i missing soemthing ?

alberto_3 - 5 years 5 months ago

Hello,
I tried many things and i could not figure out how to create a topic neither.
The only other option I can suggest is for you to use the Jaspersoft Studio. In there you can connect to your mongodb and also you can pull data directly as you would with any other datasource. I hope this helps.

oakrami - 5 years 4 months ago
show 2 more...

I have the exact same issue. The data source is added successfully, however when creating a domain it is missing from the list? The only data sources available are (jasperserver repository sql data source, jserver jdbc data source, jserver jndi data source, sugarcrm-foodmart virtual data source). The added data source is no where to be found within the "Add New Domain" wizard. I can see the data source when clicking on view list for data sources.

clifton.dillman - 5 years 3 months ago

I am getting this same issue on AWS. Do I need to use Jaspersoft Studio to define a topic? I can save the MongoDB datasource but then can't use it to define any topics.

joe_10 - 4 years 9 months ago
Feedback
randomness