LedgerBridge and LedgerBridge Connector

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. 

Prerequisites

  • 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 

  1. Prepare Record Definition in Gospel: Create Record Definitions and add the required fields in Gospel
  2. Prepare Source File: Provide a valid data source file (local or URL) 
  3. Map Source to Destination: Define the mapping (definitions.properties file) 
  4. Configure and start LedgerBridge 
  5. 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.


FileName

Ledgerbridge

gospel-ledgerbridge-<version>.jar

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. 

File
Jar
LedgerBridge Connector ledgerbridge-connector-<version>.jar

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

Collectors

The relevant collector file depending on the location of file you want to import (local or online).

Transformers

The relevant transformer file for the type of file you want to import.

To import from a file 
CSV



ledgerbridge-connector-collector-file-<version>.jar

Used to import data from a local source file to Gospel.

ledgerbridge-connector-transformer-csv-<version>.jar

JSON
ledgerbridge-connector-transformer-json-<version>.jar
XML
ledgerbridge-connector-transformer-xml-<version>.jar
FLATFILE

ledgerbridge-connector-transformer-flatfile-<version>.jar

To import from an HTTP location
JSON


ledgerbridge-connector-collector-http-<version>.jar

Used to import data from an online source file to Gospel.

ledgerbridge-connector-transformer-json-<version>.jar

XML
ledgerbridge-connector-transformer-xml-<version>.jar
To import from a data base (JDBC)
JDBC

ledgerbridge-connector-collector-jdbc-<version>.jar

ledgerbridge-connector-transformer-json-<version>.jar