YouTube Analytics Setup
Understand how your videos are performing to create engaging content.
Systems | Development | Analytics | API | Testing
Modern Software Development For Today's Systems & Applications
S3 Integration Setup
Consolidate your disparate files from S3 into your analytics warehouse.
Aceable Switches From Alooma to Fivetran, Eliminates ETL Maintenance
After Alooma announced it was sunsetting its services for Redshift customers, Aceable moved to Fivetran for data integration. In one week, the business integrated all of its sources, including MongoDB — a project that was never completed with Alooma. With Fivetran, Aceable eliminates the need for back-end maintenance and adds Jira to its stack to track project progress across the entire org.
How to work with webhooks
As always, we start with giving our flow a meaningful name. Now let’s add a webhook. There are four authentication options for a webhook on our platform, just visit our documentation to learn more about it, but to keep it short and simple,
Speed Up Development With Powered by Fivetran
Powered by Fivetran (PBF) provides a simple framework for developers to go beyond internal analytics projects to build data pipelines into their applications within the Fivetran platform. With no engineering overhead, you can easily access hundreds of customer accounts across countless Fivetran-supported data sources, including advertising platforms, CRM systems, databases, web events and more.
How to add and manage credentials on elastic.io
To use most of the available connectors you require to enter some sort of credentials to verify the account you want to access with a connector. You can add your credentials while setting up an integration flow as I’m doing it here on the example of the pet store connector.
How to handle errors on elastic.io
You can see if any of your flows have errors as soon as you log in to your dashboard. It shows you the number of records processed in total – in green – and the number of records with errors – in red. You can also see the same information if you click on the corresponding flow from the dashboard. In my case, you can see I have three records processed and all three returned errors.
Advanced data mapping techniques - The passthrough feature
Let’s start by naming our flow. Here we are taking the webhook connector as our trigger. In case you skipped our previous short tutorial on webhooks, you need to copy this link and paste it in an empty tab to receive a sample. Now we are going to modify the sample – or correctly speaking, add it manually. These are just sample values to demonstrate how the passthrough feature works, so there is no point in seeking any deep meaning in them.
Creating value from legacy data - The whys and the hows of legacy system integration
While there are many challenges young companies might struggle with, they certainly escaped one that is a blessing and a curse at the same time – the legacy IT systems. Data is indeed one of the companies’ most valued assets, as knowledge (read, ‘data’) empowers better, more informed business decisions. Moreover, chances are your organization already has most of the knowledge it needs. The only caveat, though, is that it might be inaccessible and therefore, pretty useless.
MySQL Setup
Integrate your MySQL database with popular data warehouses such as BigQuery, Snowflake, Redshift, or Delta Lake by Databricks.