Timeline for Custom Report from xDB (MongoDB) based in Geo Ips
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 3, 2017 at 5:11 | comment | added | Amitabh Vyas | Agreed, Mongo is not relational rather it stores on BSON format. Hence we are writing Mongo Scripts (Using MongoChef as GUI) to query the Interaction collection for the required data. | |
| Dec 1, 2017 at 23:11 | comment | added | Richard Hauer | The raw data is in Mongo. Note that Mongo is not a relational dB, so you can't "join" to the GeoIP collection | |
| Dec 1, 2017 at 19:49 | comment | added | Amitabh Vyas | Will give it a shot with the Map/reduce, but my understanding is correct right that Siteore OOB doesn't store the GeoIP data in Reporting DB at all? | |
| Dec 1, 2017 at 17:10 | comment | added | Richard Hauer | Yes, that's right. Be sure to add indexes to MongoDB to ensure queries are as efficient as possible. Try to structure your query using Map/Reduce or the aggregation framework, rather than relying on C# to do the rollup. You will find Mongo is very good at processing data this way. | |
| Dec 1, 2017 at 16:43 | comment | added | Amitabh Vyas | Its a Monthly Report Richard. You mean creating a connector between Mongo and SQL, which pulls the data from Mongo convert it to the Relational DB format and save it to SQL. Is that correct ? | |
| Nov 30, 2017 at 23:29 | history | answered | Richard Hauer | CC BY-SA 3.0 |