Import data from External Data Sources
LedgerBridge saves hours of your time spent on large data migration to Gospel. It enables you to move structured content easily, thus, eliminating the need to manually map content to the Gospel platform. The primary utility that makes this possible is the Gospel LedgerBridge Connector which supports importing content from external data repositories in the CSV, XML, JSON, Database and Flat file formats.
- 2 vCPU
- 1GB RAM
- 100MB disk space
- Download JRE version 1.8 from the Java download page
- Download the required JAR files
- Valid certificate and private key. You can download the certificate and private key for the current session from the Tools > Certificate Tools page.
Steps for importing records from source files to Gospel
- Prepare Record Definition in Gospel: Create Record Definitions and add the required fields in Gospel
- Prepare Source File: Provide a valid data source file (local or URL)
- Map Source to Destination: Define the mapping (definitions.properties file)
- Configure and start LedgerBridge
- Configure the properties file for the type of file you want to import and start the LedgerBridge Connector
Downloadable JAR files
Download the JAR files from the Gospel Dashboard > Downloads section.
LedgerBridge JAR file
Ensure that the LedgerBridge JAR file and the properties file are located in the same directory.
LedgerBridge Connector JAR file
Ensure that the LedgerBridge connector, collector, transformer JAR files, the properties file (applications.properties) and the definitions file (definitions.properties) are located in the same directory.
LedgerBridge Collector and Transformer JAR files
The table below lists a combination of collector and transformer required for the type of file you wish to import.
|Import File Type|
The relevant collector file depending on the location of file you want to import (local or online).
The relevant transformer file for the type of file you want to import.
|To import from a file|
Used to import data from a local source file to Gospel.
|To import from an HTTP location|
Used to import data from an online source file to Gospel.
|To import from a data base (JDBC)|