Jump to content
Changes to the Jaspersoft community edition download ×

Best solution to integrate data from different sources through apis


Kendjr

Recommended Posts

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!

 

Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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/

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...