Create and Connect
Create and Connect

Create and Connect

image

A Datastore is a view of your data repository — it defines how Eightwire will connect to the data.

A Datastore can be a source or a destination and each one can vary in the required connection inputs and in its features. For example, a CSV Source datastore allows for a wildcard to be set and a datastore on a relational database allows for queries to be built in the datastore.

To see all the available connectors and their features go to: Connectors

image

Create a Datastore

The steps to set up a datastore also include the option of downloading and connecting a new Agent (refer to our section Installing an Agent for detailed information).

  1. Navigate to Datastores and click +Add
  2. Name your datastore and provide an optional description.
icon

If you plan to share the datastore with another organisation it is good practice to include your organisation name in its title.

3. Click Next

image

4. Select whether the data you are connecting to is on premise or cloud hosted.

5. Select a connector type and click Next

6. Select an Agent and click Next

Don't have an Active Agent? Check out all you need to know about installing here: Install an Agent

7. Connection

Provide the instructions to connect to your data.

The instructions will vary depending on the datastore Type - for example;

  • a database connection string
  • a folder path
  • cloud provider credentials

The example shown connects to a SQL database

image

Click Next and the datastore will perform a connection test.

image
image

8. Configure the datastore

Choose whether the datastore is being used as a source or a destination.

  • Maximum concurrent reads: this defines how many parallel processes can be run using objects in your datastore.
  • Scan process — choose Automatic or Manual
  • A scan looks at the underlying repository and gather information on its tables, columns and data types. This is done first when you create the datastore and the information assists with smart mapping and detecting unexpected data structure changes.

Automatic Scan periodically allows Eightwire to re-scan and refresh its cached scan of your data structures.

Manual Scan only does this when requested - using the scan button on the datastore. If your underlying repository data structures change, you should re-scan the datastore to ensure you are working with accurate data structures.

Click Next

icon

Eightwire will scan each object used during a data transfer and report a warning if the cached data structure differs from the actual data structure in a way that is incompatible.

icon

The data source you are transferring data to must have the same Region selected, or not lock their datastore to a Region for the process to work.

9. Data Sovereignty

Selecting an option from the drop-down means that you are restricting any transfer of data to use a Processing Server with data center in a particular Region.

10. Click Create

image

Watch the steps to set up an Excel Datastore

icon

Always finish the steps to create a datastore and check the scan of the datastore objects before you use the Datastore Sharing tab.

image

Nice work!

You have completed your datastore setup.

If your data repository already contains objects, have a look at the options available to confirm the scan has correctly reflected the data structure and work with the data presentation: Scan, Browse, and Edit Objects

Next Steps:

If your datastore uses a relational database, then you have the option of creating datastore queries — check information about that on this page: Datastore Queries

If your datastore is a source CSV, then you have the option of creating a wildcard (for applying a naming convention to files that will be read from the source folder). Check out how to apply wildcards: CSV Datastore Wildcards

If you are creating a Tile Datastore to share with an Associated Account or another full license Account, there are specific Datastore configuration options shown here: Tile Datastores