3 ms·
Indeed, MongoDB BI connector v1 was based on PostgreSQL. However, they used 9.4's foreign data wrappers and since those could not push down query clauses, the c
by ahachete 10y ago
Indeed, MongoDB BI connector v1 was based on PostgreSQL. However, they used 9.4's foreign data wrappers and since those could not push down query clauses, the connector itself introduced a significant performance degradation (on top of MongoDB's current performance difference when compared to Stampede/PostgreSQL).
- eb0la 10y agoI've tried that connector and decided against using it. The problem was you had to define your schema by hand and in mongo sometimes you have legacy data records with different semantics. In my case it crashed Tableau data import after 45 minutes because it blindly sent data that shul have been NULLIFIED. Will take a look at the way Stampede does the transformation. It might suit us.
- gortiz 10y agoGreat! We are looking forward to hear from your experience! Open a ticket on github or email us if you find problems or do you think there is something we can improve!