SchemaMapper 1.1.0

A .NET class library to import data from different source into a unified destination

Install-Package SchemaMapper -Version 1.1.0
dotnet add package SchemaMapper --version 1.1.0
<PackageReference Include="SchemaMapper" Version="1.1.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add SchemaMapper --version 1.1.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: SchemaMapper, 1.1.0"
For F# scripts that support #r syntax, copy this into the source code to reference the package.
// Install SchemaMapper as a Cake Addin
#addin nuget:?package=SchemaMapper&version=1.1.0

// Install SchemaMapper as a Cake Tool
#tool nuget:?package=SchemaMapper&version=1.1.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

SchemaMapper

SchemaMapper is a data integration class library that facilitates the data import process from external sources having different schema definitions. It replaces creating many integration services packages by writing few lines of codes.

It imports tabular data from different data sources such as into a destination table with a user-defined table schema after mapping columns between source and destination.

SchemaMapper has the ability to read data from:

  • Excel worksheets (.xls, .xlsx)
  • Flat files (.csv, .txt)
  • Access databases (.mdb, .accdb)
  • Web pages (.htm, .html)
  • JSON files (.json)
  • XML files (.xml)
  • Powerpoint presentations (.ppt, .pptx)
  • Word documents (.doc, .docx)
  • Relational databases (SQL Server, Oracle, MySQL, SQLite, SQL Server compact)

And it can export data into different destination types:

  • Flat files (.csv, .txt)
  • XML files (.xml)
  • Relational databases (SQL Server, Oracle, MySQL)

In addition, it allows users to add newly computed and fixed valued columns.


Used technologies

SchemaMapper utilizes many technologies to read data from different sources such as:

Note: The needed Assemblies are found in the Assemblies folder but it is recommended to install the assemblies related to the providers that you want to connect to from the official links (mentioned above) since they can require more related assemblies


Project details

SchemaMapper is composed of four main namespaces:

  • Converters: It reads data from external files into DataSet
  • DataCleaners: Cleans files before importing
  • SchemaMapping: Changes the imported data structure to a unified schema
  • Exporters: export tables to external sources

Wiki


Credits:

Credits are for Munchy Bytes™


SchemaMapper

SchemaMapper is a data integration class library that facilitates the data import process from external sources having different schema definitions. It replaces creating many integration services packages by writing few lines of codes.

It imports tabular data from different data sources such as into a destination table with a user-defined table schema after mapping columns between source and destination.

SchemaMapper has the ability to read data from:

  • Excel worksheets (.xls, .xlsx)
  • Flat files (.csv, .txt)
  • Access databases (.mdb, .accdb)
  • Web pages (.htm, .html)
  • JSON files (.json)
  • XML files (.xml)
  • Powerpoint presentations (.ppt, .pptx)
  • Word documents (.doc, .docx)
  • Relational databases (SQL Server, Oracle, MySQL, SQLite, SQL Server compact)

And it can export data into different destination types:

  • Flat files (.csv, .txt)
  • XML files (.xml)
  • Relational databases (SQL Server, Oracle, MySQL)

In addition, it allows users to add newly computed and fixed valued columns.


Used technologies

SchemaMapper utilizes many technologies to read data from different sources such as:

Note: The needed Assemblies are found in the Assemblies folder but it is recommended to install the assemblies related to the providers that you want to connect to from the official links (mentioned above) since they can require more related assemblies


Project details

SchemaMapper is composed of four main namespaces:

  • Converters: It reads data from external files into DataSet
  • DataCleaners: Cleans files before importing
  • SchemaMapping: Changes the imported data structure to a unified schema
  • Exporters: export tables to external sources

Wiki


Credits:

Credits are for Munchy Bytes™


Release Notes

https://github.com/munchy-bytes/SchemaMapper

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.1.0 278 4/13/2020