Mongo Report

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');