Once a data reader and writer are connected, it is possible to start graphically building the transform, dragging data from the source to the target.Ī simple wizard is used to add the Database reader to the transform. Standard components allow the database results to be The database schema structure is then represented hierarchical in the data mapper using the relationships and

The Database reader supports Microsoft SQL Server, Oracle, MySQL, PostgreSQL, SQLite, VistaDB data sources, simply use the wizard to connect to yourĭata source. Once added, the Database reader can be expanded to access tables with constraints/relationships defined within the database. Rest and SOAP Web Services: Supports OpenAPI (Swagger) and WSDL Web Servicesĭata can be read and written between multiple different data sources and data targets.Text files: Fixed field flat file and CSV file.Databases: Microsoft SQL Server, Oracle, MySQL, PostgreSQL, SQLite, VistaDB.

Support is provided for a wide range of data stores: Mapping data between different data formats

The transform can also be executed within your own application by generating XSLT or C# source code. The transformations are ideal for converting legacy data to new data formats, or for inclusion as part of your data pipeline, transforming data between diverse, heterogeneous systems.Įach transform can be executed within the Liquid Studio environment and debugged by single stepping through them to display the internal state of the engine to be viewed, and path of execution. The transforms can map multiple data input sources to multiple data output targets while performing conditional logic, filtering, string manipulation, statistical functions and much more Liquid Studio Data Mapper provides an intuitive graphical interface for designing data transforms.

Json wizard