K2 Best Practice, Part 1: Blackpearl Workflow
The great thing about K2 software is that there are many different ways of doing things and a negative thing about K2 is that there are many different ways doing of things! Poorly designed workflows and SmartForms can have a major effect on solutions' performance and...
How to open a file with a system default application in Talend Studio
User Case What if you are asked to black-box a Talend job? Would it not be great if you could tell Talend Studio to open the output file when it is produced automaticaly? Or to prompt the user if he wants to open the rejects file and view any rejects that were...
Committing to a MySQL Database in Talend Studio
Case Scenario You might have come across an issue in Talend Studio when using a MySQL standard Talend component. The issue being an incorrect commit to the database resulting in some rows being left out of the commit statement. For instance if you insert 2633 rows of...
Scheduling Talend Open Studio Jobs in Windows without (Talend Administration Center) TAC
User Case So you want to run your Talend job automatically based on a specific schedule. If you are working on a Windows machine, then you probably head of Task Scheduler. This article will give a full guide on how to build a job in Talend Open Studio and make it run...
Scheduling Talend Open Studio Jobs in Linux without (Talend Administration Center) TAC
User Case So you want to run your Talend job automatically based on a specific schedule. If you are working on a Linux machine, then you probably know of Crontab. This article will give a full guide on how to build a job in Talend Open Studio and make it run on a...
An agile workforce with digital capability at their fingertips
"By 2020, it is estimated that the average person will have seven connected devices, that's up from three in 2014". That statistic was recently highlighted by Accenture on LinkedIn and it prompted this thought: what could that actually mean, would those seven devices...
Twitter Sentiment Analysis using Talend
This post will cover how to extract data from Twitter using custom components in Talend open studio as well as a simple method for performing sentiment analysis on the twitter data. What's the point? Before discussing how we extract twitter data and perform sentiment...
Think Cloud for Government 2015 – Prepping the Public Sector
On Tuesday 10th February, Datalytyx attended the Think Cloud for Government event at the Business Design Centre in North London for a thought-leadership event aimed at government officials, procurement professionals and independent analysts. Matt Schroeder, Adrian...
Datalytyx becomes a Crown Commercial Service Supplier
Datalytyx has been awarded G-Cloud 6 framework inclusion to become a Crown Commercial Service (CCS) Supplier for 2015-2016. Our services are now available from the UK Government's Digital Marketplace (https://www.gov.uk/digital-marketplace) under the name of Managed...
Using tMemorizerows in Talend to aggregate items to a parent
Sometimes, data extracted from systems will contain rows that are actually parent line items with child line items underneath. For example, you might be working with a travel and expense system that lists a parent item like 'Travel' and then child items like 'Car...