How to share spotfire files and not lose sql connections?

[Dallas Dye 2]

I'm new to sql connections and spotfire but I built an analysis tool with connections to sql and excel sheets. My group has access to the excel sheets and the sql database now. The only way I was able to take my file and have it be usable on another members computer was to replace the data file. Once I did that I had to reconnect all my joins of excel sheets. Any help is appreciated.

​

Thank you,

Dallas​

[Fredrik Rosell]

Hello Dallas,

How are you connecting to the database? Assuming that "sql database" means "SQL Server database", there are three primary ways you could be connecting to it, with the first two the generally recommended ones:

• Using a Connector - you use that when adding a data source from the Files and data fly-out (the "plus" sign) > Connect To
• Using Information Services - you use this when using (server-side) Information Links, created using Data menu > information designer
• Using ODBC/OLEDB - you use that when adding a data source from the Files and data fly-out (the "plus" sign) > Other > Load data with ODBC, OLE DB, or ADO.NET data provider. This

See "Open from Database Overview" in the Analyst manual for more information on these different methods:

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

Based on your problem description, I'm guessing that maybe you are connecting using the third option, using ODBC and a DSN that only existed on your machine - not the other machines. If so, I would suggest trying using the connector (Microsoft SQL Server Connector) instead. Note: most connectors require a driver to be installed separately on each computer where it will be used but that is not needed for SQL Server, where the driver comes with .NET - always check the system requirements to check that: https://docs.tibco.com/pub/spotfire/general/sr/sr/topics/spotfire_connectors_12_4.html#GUID-C284FD89-0A07-4F15-9902-BE3ABD1EBB41__TABLE_54C291BB27EB4696BDF9A19C1C138943

You can read more about using the SQL Server Connector in this page in the Analyst manual:

https://docs.tibco.com/pub/sfire-analyst/12.4.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=connectors%2Fsql%2Fsql_details_on_microsoft_sql_server_connection.htm

If my assumption about this is incorrect, please elaborate on the problem you faced - did you e.g. get any error message.

 

[Dallas Dye 2]

Your assumption was correct, i'm using the ODBC connector to the cloud based sql database. When i loaded the file i placed on the new computer, it asked for the credentials to connect and when it was finished, it did not bring in data.

[Fredrik Rosell]

Hello Dallas,

Did you use the same credentials to connect on the new computer or the credentials of that other member who's computer you were using (in reference to "usable on another members computer ")?

This would likely be easier for the Support team to assist you, so they could take a look at how your dxp file is configured, logs etc, so I recommend opening a case for this in the TIBCO Support Portal - http://support.tibco.com.

Best Regards

Fredrik (TIBCO Support)