Product: TIBCO Spotfire®
How to connect to Microsoft Azure SQL Server database with Information Links via JDBC.
Product: TIBCO Spotfire Server Version: All Supported OS: All Supported Operating Systems -------------------- Product: TIBCO Spotfire (desktop client / Analyst / Professional) Version: All Supported OS: All Supported Operating Systems -------------------- Database: Microsoft Azure - SQL server The following describes one method to connect to a Microsoft Azure SQL Server database instance using Information Links and a JDBC connection from the TIBCO Spotfire Server. You can connect to the Microsoft Azure's SQL Server database via the Information Designer. Here are the steps: 1. Log into your Microsoft Azure. On the left panel, click on “SQL Databases”. 2. Click on the name of the database. In the attached example this is “Spotfire”. 3. Under “Connect to your database”, click on the link: “View SQL Database connection strings for ADO .Net, ODBC, PHP, and JDBC”. 4. A pop up window will open. Copy the JDBC string. For example: o jdbc:sqlserver://myserver.windows.net:1433;database=myDatabase;user=support@myserver;password=mypassword;encrypt=true;hostNameInCertificate=*.database.windows.net;logingTimeout=30; 5. Click on the link “firewall rules” and add the external IP address of your TIBCO Spotfire Server. o Note: You can find the public IP address by e.g. going to http://www.whatismyip.com/ . Your internal network must allow the connection from the TIBCO Spotfire Server to the Microsoft Azure instance. 6. Open the TIBCO Spotfire Analyst/Professional client and go to Tools > Information Designer. Add a new data source by clicking the “Create Datasource” link and use the JDBC string URL from step 4 for the Connection. 7. Now you can create Information Links using your new data source which is configured to access your Microsoft Azure SQL Server database instance. Microsoft Azure: https://azure.microsoft.com