Process to connect Spotfire to Blob/Azure Cloud

[Sanjay Sen]

Hi All,

I wanted to know the process of connecting Spotfire client to Blob/ Azure Cloud.

If anyone can provide detailed guidance on this.

I have seen the below solution, but need some more explanation.

https://www.youtube.com/watchv=32OOGWFydw0

Thanks.

[Harshith Reddy Musku]

Hello,

Video shows how you can connect to Azure SQL Database using Microsoft SQL Server connector available in Spotfire. But if you are looking to connect to Blob Storage, you have to either import those filesinto SQL Server or one other option you can try is Odata connector (Add data tables->connection to->odata) if that data is exposed as a service. Beyond that it will be an enhancement request to add support for Azure Blob Storage as data source.

https://docs.tibco.com/pub/sfire-analyst/7.11.1/doc/html/en-US/TIB_sfire...

[Sanjay Sen]

Hi Harshith,

 

I have tried to connect using the OData Connector, but I am getting an error while connecting.

 

I am following the procedure mentioned in the link: 

 

https://docs.tibco.com/pub/spc/4.0.0/doc/html/odata/odata_loading_data_from_microsoft_azure_marketplace.htm_ga=2.247994946.451010743.1551092919-763608420.1527084145

 

Error: The remote server returned an error: (404) Not Found.

 

The DataSource Does not Exist or it does not respond.

 

Can you help me out with the error resolution

 

Thanks,

 

Sanjay 

[Harshith Reddy Musku]

Hi Sanjay, Odata is generally used to access data from web services. So data should be exposed as service before making connection from Odata. However, that is just one of the test. But connection to Blob storage is never tried or tested. As mentioned, you can add an enhancement request to support Blob storage as data source, in the ideas portal https://ideas.tibco.com