Has anyone been successful using Talend Studio to access data through the Cube.js SQL API? I'm curious what component would be used to access the data.
Please refer to the cube.dev documentation for information on the cube support REST API, which allows Cube to transmit data via the HTTP protocol. You can use curl utility to execute requests to the REST API. In Talend Studio, you can use a tSystem to execute the curl command.
Thank you Shicong. I am aware that a REST API exists. However, since I will be using this in a data warehouse scenario and will be loading data from 100+ tables, this approach would be quite painful.
Their site mentions a SQL API that is based on PostgreSQL.
I am guessing that I may be able to use this Talend component tpostgresqlinput
I'm curious if anyone has experience accessing data this way.
I apologize for the delayed response. You are correct, the document does state that 'in general, if an application can connect to a PostgreSQL database, it can also connect to Cube'. Unfortunately, I don't have an environment set up for testing. Have you given it a try with tPostGresqlnput or tPostgresqlConneciton for a connection to Cube? Did you encounter any errors?
I do not have an environment to test this at this time. My question relates to accessing a future version of Huron Research Suite data coming in version 12. The Huron team is creating a new way for customers to access our data using Cube.js. I am hoping to test this when it is available to customers.
Since my original post, a contact at Huron successfully tested the PostgreSQL components available in Pipeline Designer, but we have yet to test this in Talend Studio. So this approach does seem promising.
