Dallas Dye 2 Posted April 27, 2023 Share Posted April 27, 2023 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 Link to comment Share on other sites More sharing options...
Fredrik Rosell Posted April 28, 2023 Share Posted April 28, 2023 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 ToUsing Information Services - you use this when using (server-side) Information Links, created using Data menu > information designerUsing 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.htmBased 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_54C291BB27EB4696BDF9A19C1C138943You 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.htmIf my assumption about this is incorrect, please elaborate on the problem you faced - did you e.g. get any error message. Link to comment Share on other sites More sharing options...
Dallas Dye 2 Posted April 28, 2023 Author Share Posted April 28, 2023 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. Link to comment Share on other sites More sharing options...
Fredrik Rosell Posted April 28, 2023 Share Posted April 28, 2023 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 RegardsFredrik (TIBCO Support) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now