Using Datastore Tags

Data structures can be tagged with arbitrary labels, giving them additional meaning. They can be used as a data dictionary or to highlight data that contains PII (Personally Identifiable or other notifiable information. You can also build a hierarchy using tags. Processes that use tagged data can be reported on — check out the information in Account Group and Communities

Datastore Wildcards

If you need to transfer data from CSV or Fixed Width files, it is likely that they are being created with a varying filename to identify the date and time of creation. In the CSV and Fixed Width Datastores there is a function to store wildcards so that the filename used in the process is constant but each of the actual files can be processed.

Datastore Queries

If a Source Datastore contains objects from a relational database, then a datastore query can be used to create and transform a set of data. The query is then visible in a shared datastore and can be used in a process. There are 13 Datastores that allow datastore queries — find the full list at Connector Types

Folder Datastores

This type of datastore enables a file of any type to be moved — for example, PDF, Word, or Image files. Most connectors extra structured data from the platforms they connect to. The Folder connector is a binary connectors, and does not make any attempt to extract data from the platforms. Instead raw binary is read and written instead. This is represented with Eightwire as structured tabular data with a binary component.

Tile Datastores

A Tile Datastore enables a data provider to drag a file into a data sharing tile, triggering a process to a destination in your account. The Tile Datastore is a cloud connector, meaning that the source does not need an Agent to interact with it. Although it can be used by any Licence type — Tiles are specifically designed for Tile Licence Accounts — where the sharing can be quickly deployed for ad-hoc shares of data or files.

FTP / SFTP Datastores

Eightwire enables you to write and read data with external organisations who are using SFTP or FTP Servers without any change to their existing infrastructure and without them needing to have their own Eightwire Account. We have a connectors that can read and write data using CSV or Excel files located on FTP/SFTP Servers. The data can be processed between the FTP/SFTP Datastore and any other Datastore (file or relational database) We also have a Generic FTP / SFTP Datastore - specifically for copying files regardless of their extension type. The files can be moved between FTP/SFTP Datastores and Folder Datastores.

Fixed Width Datastores

When working with file sources that do not have column headers — Eightwire will attempt to identify columns in the scan using the delimiter settings, and apply arbitrary column labels. This page shows how to create a Fixed Width Datastore and options to edit the datastore to apply any documented column widths and descriptions to the datastore objects.

Teradata Datastores

This section details requirements to connect using our Teradata Connector.

Datastore connection to AWS

This section details requirement examples of connections to AWS using our connectors for S3 Delimited Text, and Relational Databases in an EC2 instance.

Salesforce Connector

Connecting to your Salesforce Account using an Eightwire datastore enables you to read and write data to standard or custom objects. The Datastore can be used after you setup access using the Salesforce Platform Tools. Once the Datastore is connected it can be shared with another Eightwire Account or used in a process for data transfer.