QueBIT Value
Euclid Studio: Call a Flow from a REST Client
In this video you will learn how to call a Euclid Studio Flow from a REST Client. This example leverages the Euclid Studio REST API.
Read MoreEuclid Studio: Clean a Column in a Text File
This video walks you through an example of how you can perform Text Cleansing in Euclid Studio. You will learn how to clean up text in various columns of your data pipeline.
Read MoreHow Do I Use the SQL GROUP BY Statement to Aggregate Data in Queries?
So far, we have gone over the SELECT, FROM and WHERE clauses. These three clauses are used to control what we are seeing in a view. What if we want to control how what we are searching for appears in the view, that is where GROUP BY comes in. The GROUP BY clause is used…
Read MoreHow Do I Use the SQL ORDER BY Statement to Sort Query Results?
Similar to the GROUP BY clause, the ORDER BY clause also determines how the data is displayed in the view and not so much what the view is displaying. The ORDER BY clause controls the order in which records appear in a view. The order can be determined by the numerical magnitude if it is…
Read MoreWhat Are SQL Joins and How Do I Use Them to Combine Data from Multiple Tables?
Now that we have set a basis for how to control a view from one table, we should have enough knowledge to tackle how we incorporate information from two or more tables into one view. Joining in SQL is extremely useful and is used time and time again in a relational database. Often times we…
Read MoreEuclid Studio: Navigating the Business Rules Node
Using the Business Rules Node in Euclid Studio is an extremely effective way of managing business rules, giving you total control over their scope and impact. It’s important to understand the tool’s options and settings before adjusting or implementing new rules. In this example, we’ll go through the basic options and settings of the node.…
Read MoreEuclid Studio: Connecting to a database via JDBC
When using an ETL and modeling tool like Euclid Studio, it’s extremely likely that you’ll want to access your relational databases. The following steps will walk you through configuring a JDBC connection within a Euclid Studio flow. Once you’ve logged into Euclid Studio and created/opened your flow, hover over the ‘Server’ menu at the top…
Read MoreEuclid Studio: Running a Flow
When creating a flow in Euclid Studio, you may want to run a single node to perform a single operation or run an entire flow of nodes. This article will review the options you have to run processes within the context of the Euclid Studio application. Before we get into the how, it’s important to…
Read MoreHow Do I Create a Microsoft SQL Server ODBC Data Source on Windows for Database Connectivity?
ODBC, or Open Database Connectivity, is a standardized way for outside programs to connect to database management systems. In this article, we will show you how to set up an ODBC data source connection to a Microsoft SQL Server instance on Windows. Opening the Program The first step is to find and open the ODBC…
Read MoreEuclid Studio: Introduction to Nodes
This video introduces you to the Euclid Studio canvas where you can interact with Nodes. Nodes are used to capture your business logic. Each Node has a specific purpose, and many Nodes can be used in combination to achieve your desired outcome.
Read More