Yellowfin JDBC mongodb driver problems

Rory Miller shared this problem 2 months ago
Defect Logged

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

Comments (10)

photo
1

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

photo
1

Hi Tom,

i am only currently using one database on my data source connection. My issue is when i update a collection on mongdb it isn't updated on yellowfin. If i delete the <somename>.mongodb.native file though and click on the data source i am using in admin console it will recreate this file with the update made. Sometimes i have to restart yellowfin to achieve this

photo
photo
1

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

photo
1

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

photo
1

Hi Rory,

What is the connection string and driver you are using for this?

Regards,

Nathan

photo
1

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

photo
1

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

photo
photo
1

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

photo
1

its no problem. keep me updated on the progress of this defect

photo