Category
Data Sources
Product Version
7.3
Yellowfin JDBC mongodb driver problems
Resolved
Hi,
i have successfully added the jdbc driver so i can use my collections on mongodb in yellowfin but my problem is whenever i add a new data base to my server the data source doesn't seem to update to add this. The only way i have been successful in getting new collections added was to create a new datasource but change/add the schema directory in the connection string
Any help would be great!
Thanks
The same problem 
Hi Rory,
While I am not familiar with all of the intricacies of MongoDB, Yellowfin can only handle one database per data source connection. So each new database you add, you must create a new data source connection with that database in the connection string. The tables within the database should be available immediately, there is no requirement to create a new data source connection when simply adding tables to a database.
Thanks!
Tom
Hi Rory,
While I am not familiar with all of the intricacies of MongoDB, Yellowfin can only handle one database per data source connection. So each new database you add, you must create a new data source connection with that database in the connection string. The tables within the database should be available immediately, there is no requirement to create a new data source connection when simply adding tables to a database.
Thanks!
Tom
Thank you for the clarification Rory. What you are describing sounds like a bug, but I will need to replicate this in order to confirm that. I should be able to let you know either way within the next couple of days here!
Regards,
Nathan
Thank you for the clarification Rory. What you are describing sounds like a bug, but I will need to replicate this in order to confirm that. I should be able to let you know either way within the next couple of days here!
Regards,
Nathan
Hi Rory,
A quick update here, I have run into problems getting my MongoDb going to replicate on. Hopefully I will have this going by the end of the day, but if not I will get something to you early next week. Sorry for the delay on this one.
Regards,
Nathan
Hi Rory,
A quick update here, I have run into problems getting my MongoDb going to replicate on. Hopefully I will have this going by the end of the day, but if not I will get something to you early next week. Sorry for the delay on this one.
Regards,
Nathan
Hi Rory,
What is the connection string and driver you are using for this?
Regards,
Nathan
Hi Rory,
What is the connection string and driver you are using for this?
Regards,
Nathan
mongo jdbc driver and my connection string is just to my localhost and default port and a random directory schema to store files on. don't need the schema but in order to refresh my data i need to delete a certain file in that directory
mongo jdbc driver and my connection string is just to my localhost and default port and a random directory schema to store files on. don't need the schema but in order to refresh my data i need to delete a certain file in that directory
Hi Rory,
Unfortunately I am still having difficulty establishing a data source connection to my MongoDB, can you please link the exact driver that you downloaded?
My apologies on the delays here.
Regards,
Nathan
Hi Rory,
Unfortunately I am still having difficulty establishing a data source connection to my MongoDB, can you please link the exact driver that you downloaded?
My apologies on the delays here.
Regards,
Nathan
Hi Rory,
Thank you for your patience here. I was able to replicate this issue and have raised a defect ticket to address it. (#6285) Unfortunately I was not able to come up with a good work around for this that does not involve editing the configuration database.
I will keep you up to date on the status of this ticket, but please let me know if there is anything I can help with in the meantime.
Regards,
Nathan
Hi Rory,
Thank you for your patience here. I was able to replicate this issue and have raised a defect ticket to address it. (#6285) Unfortunately I was not able to come up with a good work around for this that does not involve editing the configuration database.
I will keep you up to date on the status of this ticket, but please let me know if there is anything I can help with in the meantime.
Regards,
Nathan
Hi All,
This is not actually a defect. The ODBC and JDBC drivers for mongo DB need to create a schema map in order to access the data through SQL. This schema map will not update unless you tell it to. To update the schema map run this query:
In Yellowfin, you can do this by typing this into a virtual table and validating the query. It will return a "no result set error" but the map will update, and once you reload the page, the collections will be available for selection.Nathan
Hi All,
This is not actually a defect. The ODBC and JDBC drivers for mongo DB need to create a schema map in order to access the data through SQL. This schema map will not update unless you tell it to. To update the schema map run this query:
In Yellowfin, you can do this by typing this into a virtual table and validating the query. It will return a "no result set error" but the map will update, and once you reload the page, the collections will be available for selection.Nathan
Replies have been locked on this page!