data conversion - Altova MapForce Professional Edition

Description: Data mapping tools. Altova MapForce is a graphical data mapping tool for any-to-any conversion and integration. Its powerful data mapping tools convert your data instantly and provide multiple ... of values for all data mapping nodes. View partial output during debug session. XSLT / XQuery Generation Generation of XSLT 1.0/2.0/3.0 code. XSLT transformation engine for immediate XML-to-XML conversion ... options to automate recurrent transformations. Altova Mapforce Professional Features Supported Data Formats Support for XML. Support for relational databases. Support for flat files (CSV, tab-separated, ...

Release Notes: way it supports conversion based on other EDI formats (X12, EDIFACT, and HL7). In the case of IDoc, however, the user will need to supply the configuration file that defines the format of the data ... This is used to override the element type defined in XML Schema in cases when no element data is provided or necessary. MapForce is now able to execute mappings where this attribute is used. Support for mapping ... will use the first row data as column annotations Ability to preserve value formatting in XML output  (all editions) Until now, MapForce was unable to preserve value formatting when outputting to an XML file ...

Release Notes: Option to share database connection among components- In some data mapping applications, a project may connect to the same database twice. Now, in these cases it is easy for database components ... High performance automation of data integration and ETL projects defined in MapForce is provided by MapForce Server and FlowForce Server, with MapForce Server automating data transformation and FlowForce ... projects that include multiple data mapping projects, input files, and other related assets. Users can now add links to relevant web pages and videos in their MapForce projects. The MapForce Examples project ...

Screenshots: MapForce allows you to easily associate target and source data structures using drag and drop functionality. 0 ...

Release Notes: "Sleep" function- A new sleep function is now available in MapForce that is especially helpful when integrating API calls to an AI system such as OpenAI in MapForce data mapping projects. ... to MySQL and MariaDB (as well as numerous other databases) via generic ADO/ODBC/JDBC connections for data integration and ETL projects. MapForce now supports native connections to them without the need ...

Release Notes: MapForce is now AI-ready- Since many AI systems, such as OpenAI’s GPT-4, are available via API, it is immediately possible to integrate their functionality in data transformation projects ... data processing in any data mapping project. Applications for AI-powered MapForce data integration: Sentiment analysis. Image classification. Document classification (i.e., types of legal documents ... in a system). Voice transcription and categorization. Classification of video or audio files. Enriching data with semantic metadata. Machine-translation of text columns into other languages. Creating summaries ...

Release Notes: Comments in data mapping projects- In addition to support for annotating individual connections in data mapping projects, it is now possible to add comments to source and target components to aid ... that the document is self-contained, and there are no external declarations required for parsing the document. When creating data transformation projects in MapForce, it is now possible to generate ...

Release Notes: when selecting a data transformation language for XML mappings. C# code gen for Microsoft.NET Core and.NET 5- When generating program code to implement data mapping projects, developers can now ...

Release Notes: functions (read-binary-file and write-binary-file) which allows you to include binary files such as PDFs or images as part of the export of data to XML or a database. Updated support for MariaDB- Support ...

Release Notes: data at runtime: any designated worksheets, rows, and cells from the specified file will be replaced with data from the mapping and all formatting in the existing file will be preserved as-is. All new ... Library Management system- MapForce includes a comprehensive data processing function library, and developers may also import libraries and build and save user-defined functions. In MapForce 2020r2, a new ... or Java based on XML data mapping projects in MapForce, new methods are available to declare or override namespaces for an element, or to append an element with a prefixed namespace. Support for additional ...

Release Notes: Adds the ability to paste tabular data from external sources into the Value Map table. Value Map configuration via copy/paste- The Value Map component lets you replace one value with another (such ... as replacing 1, 2, 3 with January, February, March) using a predefined look-up table. Starting with MapForce 2020, it’s possible to paste tabular data (key-value pairs) from external sources such as CSV ... stored procedures as input components (procedures that provide results) or as output components (procedures that insert or update data). Or, stored procedures may be inserted as a function-like call ...

Release Notes: New support for database tracing makes it easy to log all the changes made by a data mapping project. Full support for high resolution monitors- MapForce 2019r3 has had an extensive UI revamp ... offered by high pixel density displays to render all graphics with more precision and detail, making complex data mapping projects more vivid and easier to read. Database output logging (tracing)- New ... support for database tracing makes it easy to log all the changes made by a data mapping project to the database when the mapping runs. When tracing is on, events such as database insert or update actions, ...

Release Notes: Define data processing functions and/or default values and assign them to one or more nodes. Node functions- It is now possible to define data processing functions and/or default values and assign ... them to one or more nodes without repeating the same function multiple times- and without drawing mapping lines. Quick insert of functions and constants- MapForce includes a comprehensive library of data ... processing functions that can be dragged and dropped into a data mapping project. Now, to make inserting functions even easier, developers can double-click in any blank space in a mapping project to open ...

Release Notes: Adds additional functionality for node functions. Additional functionality for node functions- Node functions give MapForce users the ability to define data processing functions and/or default ...

Screenshots: Once you have finished defining your XML mapping and data processing rules, you can load an XML instance document as a source file, and the built-in MapForce Engine will instantly convert the data ...

Screenshots: Altova MapForce provides visual XML mapping functionality for instantly transforming XML data from one XML format to any another XML format based on XML Schema or namespace aware DTDs. 0 ...

Screenshots: Altova MapForce includes support for database mapping, including mapping between of database data and XML, flat files, EDI, Excel, XBRL, Web services, and even other database formats. 0 ...

Release Notes: Updates in 2016 Interactive data mapping debugger Support for Firebird databases Support for numerous databases updated to include newest versions Visual Studio integration updated to include VS ...

Release Notes: of representations of date and time in data transformation projects. Sometimes an input data stream includes a value that represents only the date or only the time. These two new functions make it easier to process ... these formats than the existing parse-dateTime function. Visual alignment guides- Complex data mappings with many components and functions can appear very cluttered on the screen. MapForce 2012 introduces new ...

Release Notes: Updates in 2011r2 Direct file output (data streaming) Expandable if-else component (switch statement) New function to retrieve node name Ability to search Function Library Reverse existing mapping ...