How to connect to Microsoft Azure SQL Server database with Information Links via JDBC.

How to connect to Microsoft Azure SQL Server database with Information Links via JDBC.

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:
   • 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.
   • 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 client and go to Tools > Information Designer. Add a new data source by clicking the “Create Datasource” link and use the default "SQL Server" data source template. Use the JDBC string URL from step 4 for the connection, modified with your specific details.
7. Now you can create Information Links using your new data source which is configured to access your Microsoft Azure SQL Server database instance.

See the attached PDF (Filename: SpotfireConnectionTo-MicrosoftAzure-SQLDatabaseconnection.pdf) for screen shots.

External: Microsoft Azure

• https://azure.microsoft.com