Hi, my client is using SAP Synase IQ as their analytic datawarehouse, SAP Business Object Bi platform to build BI reports. Is it possible to connect directly from Starbust to SAP-BO through custom connector?
Many thanks
Layla
1 Like
I am not aware of any connector or also how other systems can query SAP IQ. It might be possible if it has a S3 compatibility layer, or exposes some sort of standard table format and metadata. If it can be queried with JDBC connector, that might also work.
In all cases this would require more investigation and most likely custom development work.
Here is some documentation on how to build custom connectors in Starburst:
https://docs.starburst.io/latest/develop/connectors.html
Also, there apparently was an effort to add a sybase connector to the Trino project, but it was abandoned at some point:
But it might be useful as a skeleton to use in building your own.
We (Starburst) have a Customer connecting to Sybase IQ using the Generic JDBC Connector. They are using the Sybase JDBC connector to achieve this. We also have a Customer connecting to Starburst with BOBJ. We should add - these are not supported - WYSIWYG. They should work - it’s just we don’t support.
https://docs.starburst.io/latest/connector/starburst-generic-jdbc.html