Best solution to integrate data from different sources through apis

[Kendjr]

We are creating a report that includes information from various Twitter, Facebook, and Google Analytics accounts. We can get the information using the associated API's.

We are trying to decide between two different systems and was looking for help.

1) Jasper ETL. My understanding is we can quickly integrate plugins to continually retrieve the information from these sources into some type of central DB. From there we can create a report.

2) Simple Self-hosted process We create a process outside of Jaspersoft that continually retrieves information from these sources, and puts the information into a MySQL DB. From there we can use Jaspersoft to create a report using the data stored in that database.

Can you let me know if this is a logical choice, and if there are obvious benefits or limitations, to either solution?

Thanks!

 

[hozawa]

Jaspersoft ETL is just Talend Open Studio. It's a set of components to generate Java code. The code can then be compiled and made into a jar/war file to be executed by cron or some other tool

The benefit of Talend Open Studio is that it has many components and many things can be done out of the box to generate Java code.

Twitter

https://gabrielebaldassarre.com/talend/ttwitterinput/

Facebook

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F485&pi=marketplace%252F1%252Fproducts%252F485%252Fitems%252F688

Google Analytics

https://www.talend.com/blog/2016/02/26/talend-and-google-services-components-9-possibilities-to-explore/

[Kendjr]

Thank you. Therefore, for a situation like mine, where I am trying to execute an api to retrieve information into a DB, do you think it is easier to simply create a php file to do that?

[hozawa]

If you know how to use the APIs and new to Open Studio, it's probably easier to just program. If you don't know how to program, then Open Studio would be easier.