Database to database streaming with Apache Kafka and Exasol

This article shows how to efficiently feed data flows into a relational database system in near real time. This means that the data is loaded and processed when it occurs and is quickly available to the company for analytical purposes. This approach is known as real-time / near real-time processing. In contrast to (near) real-time loads are batch loads, in which data is loaded and processed at time X (for example, daily or weekly) in correspondingly large quantities. So instead of working with data that can be over 24 hours old, (near) real-time processing allows you to use very recent data. This enables companies to react faster and significantly increases the timeliness of the information content. Data from different source systems can be loaded and processed via the same stream.

Specifically, we will show how Exasol can work together with the streaming platform Kafka. In the following use case, the integration of Exasol as a sink and source system, i.e. as a target or source system, for Kafka is presented and implemented in a test example.

Automated data retrieval from the Internet

Being able to react dynamically to content on the Internet can be very helpful for automating workflows. But how can this advanced task be easily implemented? Alteryx Analytic Process Automation (APA) software provides a practical no-code alternative for business users to dynamically access a variety of data sources - including the Internet.

The purpose of this article is to illustrate how to automatically download data from the Internet, aggregate it, and save it in a variety of formats. The Excel data used comes from the SIX website, which publishes weekly updated trading reports as Excel files. The data in these reports comes from the Swiss stock exchange and contains data of securities.

What is artificial intelligence? - Part 5

To round out the series of articles on AI, this fifth and final article is about use cases: where can AI best be used to achieve business benefits? This mini-series on artificial intelligence in business is aimed at small and medium-sized enterprises interested in integrating advanced data analytics into their business processes.

What is artificial intelligence? - Part 4

This article is the fourth in a mini-series on "Artificial Intelligence in Business - What can it do and what are its limitations? And how can artificial intelligence be easily integrated into mainstream business software?"

What is artificial intelligence? - Part 3

This article is the third in a mini-series on "Artificial Intelligence in Business - What can it do and what are its limitations? And how can artificial intelligence be easily integrated into mainstream business software?"

What is artificial intelligence? - Part 2

This article is the second in a mini-series on "artificial intelligence in business - what can it do and what are its limitations? And how can artificial intelligence be easily integrated into mainstream business software?"

The Banian team has grown

Banian has three new roots. Since the end of March and beginning of April, Kirsten Kleim, Stefan Habermacher and Rahel Schaub have been working with us. Kirsten and Stefan bring a lot of experience in the areas of Data Science and Data Engineering. Rahel supports Philipp and Dominik as an executive assistant in the areas of Marketing & Sales and Partner Management. Find out more about the individual personalities by reading the short Q&A.

What is artificial intelligence? - Part 1

Artificial intelligence in business - what can it do and what are its limitations? And how can artificial intelligence be easily integrated into common business software?

Alteryx & Snowflake: Made for each other

Alteryx and Snowflake announce a joint partnership: reason enough for us to try out the possibilities right away...

The power of authenticity

Jeroen Loosli - our partner in organizational development - has written a blog post for us on the topic of authenticity in the working world. Learn why it hurts companies when employees wear masks and how a culture of authenticity can be created instead.

How to: Data Analysis in Financial Statements and Internal Audit

Today, data on corporate processes is almost completely available in electronic form. Internal and external auditors must be able to deal efficiently with the increasing amount of data. In this blog post, we show you how audit procedures can be carried out easily!

The 10 commandments of a successful digitization project

Digitization made easy? Digitization projects are not that trivial. But if you follow our 10 commandments, you can ensure that the entire potential is explored and that the first small successes can be celebrated quickly with a clear, structured approach instead of being overwhelmed.

The path to the "Data Driven Company

Digitalization demands data-driven decision-making. This blog post shows one possible approach to becoming a "Data Driven Company", as well as the challenges that need to be overcome on the way there.

How a controlling employee can save 256 working hours through automation

Process Mining with Alteryx and Celonis Snap

Do you want to know how Process Minning how it works, where it is used, what the benefits are and which requirements have to be met? Then you've come to the right place.

Bringing processes to life with Human Workflow Management Tool

Rigid process management was yesterday! With Human Workflow Management, processes are brought to life by running through them in real time, supported by a system. We test the new Human Workflow feature from Bpanda and show you how standard processes can be flexibly adapted during the run.

Automate financial processes independently - with Alteryx Designer

Many activities in the financial sector offer potential for automation. Alteryx Designer offers the possibility to determine what should be automated and how.

Using Alteryx Part 3: SVERWEIS in Alteryx - Linking tables easily

In the third and last entry of our blog series "Using Alteryx" we would like to introduce you to a common use case in data processing: Linking multiple tables. In Excel you would probably solve this with SVERWEIS (VLOOKUP) - but in Alteryx it's easier.

Using Alteryx Part 1: Reading multiple Excel files and processing them together

We've picked out three common data processing challenges and will present you with three successive blog posts on how to tackle each of these problems in Alteryx Designer. Today it's time for blog entry #1, in which we take a look at Excel.

Using Alteryx Part 2: Calculating transport routes and finding nearest warehouses

We've picked out three common data processing challenges and present to you in three consecutive blog entries how to tackle one of these problems in Alteryx Designer at a time. Today it's the turn of blog entry #2, in which we show you how to use Alteryx Designer to calculate transport routes and rank data sets based on their proximity to each other.