need help in connecting Spotfire analyst 7.8 to mongodb

[Karthik Gottipati 2]

need help in connecting Spotfire analyst 7.8 to mongodb

[Harshith Reddy Musku]

Hello,

You can use the ODBC driver available in TIBCO Drivers bundle, then create a DSN for that driver in 'ODBC data sources' and follow the steps mentioned in the document.

 

https://docs.tibco.com/pub/sfire-analyst/7.8.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/load/load_details_on_configure_data_source_connection_odbc.htm

 

You can also try usingMySQL connector as mentioned here -https://community.spotfire.com/wiki/analyzing-mongodb-data-tibco-spotfire

[Karthik Gottipati 2]

I am getting an error while setting up the odbc connection attached is the scrrenshot of the error"lost connection to mysql server at reading intial communication packet, system error :0 

[Harshith Reddy Musku]

I don't find any screenshot. Did you connect through Oracle MySQL connector or ODBC data provider

[Karthik Gottipati 2]

odbc driver[[{"fid":"167676","view_mode":"default","fields":{"format":"default","field_file_image_alt_text[und][0][value]":false,"field_file_image_title_text[und][0][value]":false,"height":"","width":""},"type":"media","field_deltas":{"1":{"format":"default","field_file_image_alt_text[und][0][value]":false,"field_file_image_title_text[und][0][value]":false,"height":"","width":""}},"attributes":{"class":"file-default media-element","data-delta":"1"}}]]

[Karthik Gottipati 2]

i attached screenshot

[Harshith Reddy Musku]

Test the connection directly from the ODBC administrator by configuring a DSN for MongoDB ODBC driver and see if are able to connect.

[Karthik Gottipati 2]

before configuring, i need to add the mongodb driver, while adding the driver i am getting the error

[Harshith Reddy Musku]

Yes, that is where you have to check. However, from the screenshot I see that is the Test result from DSN configuration window. Connection should work there before you try it in Spotfire.