Kendjr Posted October 15, 2017 Share Posted October 15, 2017 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 More sharing options...
hozawa Posted October 15, 2017 Share Posted October 15, 2017 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 toolThe 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.Twitterhttps://gabrielebaldassarre.com/talend/ttwitterinput/Facebookhttps://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F485&pi=marketplace%252F1%252Fproducts%252F485%252Fitems%252F688Google Analyticshttps://www.talend.com/blog/2016/02/26/talend-and-google-services-components-9-possibilities-to-explore/ Link to comment Share on other sites More sharing options...
Kendjr Posted October 16, 2017 Author Share Posted October 16, 2017 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? Link to comment Share on other sites More sharing options...
hozawa Posted October 16, 2017 Share Posted October 16, 2017 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. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now