Finsyght Data Gateway

Gateway Overview

Data Transfer Dashboard

Connected sources, transfer health, job outcomes, and recent throughput.

Connected tables0Active source mappings

Total rows0Rows written by jobs

Successful runs00% success rate

Failed runs00% failure rate

Avg duration0 msCompleted job runs

Transfer History

Rows / day

Run Outcome Ratio

Ready

Job Duration

Recent runs

Connected Tables

0 tables

1

Choose ERPSource package

2

Connect SourceERP credentials

3

Map FieldsImport template

4

ScheduleFrequency and load

5

MonitorSchedules and runs

Source ERP

Loading

Source Credentials

Not connected

Connection Basics

Connection Name Source System

Database Type Environment

Server Details

Host / Server Address Port Database

Schema Name optional Instance Name optional

Connection Timeout (seconds) Row Preview Limit

Authentication

Authentication Type

User Password

Protected connection string preview

Destination

Checking

Provider: SQL Server
Server: xx.xx.xxx
Database: Hidden
User: Hidden

Destination port

Table And Target

Waiting

ERP source table Finsyght import target

Custom SQL SELECT only

SQL query

Saved table name Preview limit

Source field	Type	Destination field	Required	Confidence

Monitoring

Loading

Schedules

Status Source Rows

Name	Source	Frequency	Load	Status	Last Run	Rows	Actions

Job Runs

Status Source Rows

Run Id	Schedule	Status	Started	Completed	Rows	Error Message

Logs

Status Source Target Rows

Run Id	Schedule	Source	Target	Status	Started	Completed	Rows	Error Message

Tenant Key Management

Bring your own tenant key or generate an AES-256 compatible 256-bit key in Finsyght.

AES-256

Tenant Key

Advanced Configuration

Loading

Max parallel runs Batch size

Command timeout seconds Use transactions

Table parallelism Chunk parallelism

Chunk size Use SQL bulk copy

Enable chunked extraction for large tables

Network CSV Share Mount

Waiting

Server Share Mount point

Domain optional User optional Password optional

SMB version Linux UID Linux GID

Extra mount options optional, comma separated

Mounted Drives

	Source	Mount point	Type	Files	Actions
No mounted CSV shares loaded yet.

Driver	Provider	Status	Setup Action	Install

Advanced Setup

Driver packages

Uploaded Packages

Driver	File	Size	Uploaded	Status

Sign in

ERP Data Gateway

Data Transfer Dashboard

Transfer History

Run Outcome Ratio

Job Duration

Connected Tables

Source ERP

Source Credentials

CSV File

Connection Basics

Server Details

Authentication

Destination

Table And Target

Import Schedule

Monitoring

Schedules

Job Runs

Logs

Tenant Key Management

Advanced Configuration

Network CSV Share Mount

Mounted Drives

Advanced Setup

Uploaded Packages