Skip to content
EVIDENTCORE
DatasyncherFile replication

Turn file drops into tables

Integrate structured, semi-structured and unstructured files from diverse sources into modern cloud data platforms, ready for analytics, machine learning and AI.

Talk to an expertDatasyncher overview

Delivered, implemented and supported by EVIDENTCORE

Datasyncher · Pipelines
  • sales_orders12,480 rows · 42 sSynced
  • business_partners3,106 rows · 11 sQueued
  • opportunities8,912 rows · 27 sQueued
  • gl_line_items51,337 rows · 1 m 54 sQueued
Datasyncherdelivered and supported by EVIDENTCORE
How it works

File replication in 3 steps

  1. Step 1

    Watch a location

    Point at an SFTP folder, S3 bucket, ADLS container, SharePoint library or Drive folder.

  2. Step 2

    Match files

    Use file patterns and folders to pick which files belong to which table.

  3. Step 3

    Load

    New files are parsed, typed and appended or merged into the destination.

Features

What you get with file replication

Many formats

CSV, TSV, JSON, Parquet, Avro and multi-sheet Excel.

Pattern matching

Route files to tables by name pattern, folder or extension.

Append or merge

Keep history by appending, or upsert on a key you choose.

Type inference

Column types are detected automatically and can be overridden.

File-to-file

Move files between SFTP, SharePoint, Drive, S3 and ADLS as well.

Python parsing

Handle odd layouts and headers with a Python step.

Sources

SFTPSharePointGoogle DriveAmazon S3Azure Data Lake Storage

Destinations

SnowflakeDatabricksMicrosoft FabricSFTPSharePointGoogle DriveAmazon S3Azure Data Lake Storage

Related capabilities

Database replicationHigh-volume, low-latency copies of enterprise databases.SaaS replicationSalesforce, NetSuite and Dynamics 365 into one warehouse.SAP S/4HANA replicationExtract via OData services, with no database access.

Bring one report you rebuild every month

We'll show the Datasyncher pipeline and the dashboard that replace it.

Book a demoAll products