Connector Types

Each Data Store makes use of a Connector to access data on your chosen platform. Each Connector is required to perform the same basic tasks but they accomplish those tasks in quite different ways. For example, when asked to write data, an Excel Spreadsheet Connector will create an Excel file containing the data and store it in a folder system, whereas an SQL Server Connector will execute database commands to write the same data into the database. From a user perspective, both achieve the same task, but internally they work quite differently. Because all data formats have differing capabilities and limitations, so do the Eightwire connectors that work with them. Where possible Eightwire will attempt to bridge the capability gap by inferring the missing information from the data, even where this is not provided by the data format itself. For example, the Delimited Text format does not provide any way to designate a primary key column. Instead, Eightwire analyses some of your data and infers an appropriate column for you. Conversely, most database platforms explicitly allow you to specify a primary key, which Eightwire will detect and use. This page shows our current selection - there are always new connectors on our roadmap, so let us know if there is something specific you are looking for;

Using SQL Cloud Connector

A Datastore can connect to SQL in the cloud using the correct connection string and by allowing communication outwards to Eightwire cloud services.

Using the Oracle Connector

You can connect to on-premise or cloud Oracle Datastores using the Oracle Connector.

Overview

When mapping Columns in a Process, instead of source data, you may choose to use a derived column. One type of derived column is an expression.

Arithmetic Operators

Boolean Operators

Conditional Operators

Precedence

Literals

Any expression may include literals. A literal, also known as a constant, is any non-calculated value.

Functions

A function takes zero or more parameters, performs some calculation, and then returns a single value. A wide range of functions are available to help you perform different tasks – these are listed in the table below. In addition, two specific functions, Data(name) and System(name) are also available, which return source table data and system metadata respectively — these are described [page here] Eightwire is generally case-insensitive. This means that you can write your expressions in uppercase, lowercase, or any combination, provided you spell things correctly. When providing function parameters for comparison/searching type activities, these will work no matter what their case, provided they are otherwise an exact match – pay attention to any spaces or other punctuation, these count when searching or comparing things.