Amazon S3 as Data Source in Tibco Spotfire

[Riccardo Schillaci]

Hello,

I would like to connect Amazon S3 as Data Source and read .parquet files.

 

Can you help me Thanks

[Sooriya rangasamy]

It is achievable via datafunction. I tried it and it works for me:) but you need aws IAM permissions for this.

1) Create a datafunction| Pass your aws access id, region, secret access key in it

2) use Python package: BOTO3 

3) Try listing all the objects in s3 with a button on text area
4) Once listed as "Key" which gives the s3 location click on the item and bring the data from selected obj as dataframe and load as your datasource. 

DM me on Linked-in for any help

 

[David Boot-Olazabal]

Hi Riccardo, Sooriya,

According to our documentation, it should be possible to connect to S3 using via the Amazon Redshift ODBC driver: https://docs.tibco.com/pub/sfire-analyst/latest/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=connectors%2Famazon-redshift%2Fredshift_accessing_data_from_amazon_redshift.htm&rhsearch=S3&rhhlterm=S3&rhsyns= .

Kind regards,

David

[CoC Spotfire]

Hello via this connector is there any possibility to load image format like jpeg or png (for example)?

 

This connector right now can only load basic data.

 

Thanks in advance.

[David Boot-Olazabal]

Hi CoC,

By default, this isn't possible but you could try a workaround.

If you convert the images to a binary format in S3, you should be able to decode them back into images in Spotfire, using scripting. An example of such as script can be found here.

Kind regards,

David