Connection

A reusable source or target connection. These are design-time only artifacts. Snapshots of the connections are stored within the runtime files. There is a DataConnect preference that can be set for the default location of user defined connection.

.sc.xml*

.tc.xml*

Map Editor

Text Editor

XML Editor*

Data Profile

Stores information about a data source, a field to test against data quality rules, testing rules, and information about a target where the pass or fail information is stored.

.dp

Data Profile Editor

Dataset

 

These are design-time only artifacts. Snapshots of the connections are stored within the runtime files. There is a DataConnect preference that can be set for the default location of user defined connections.

.src.dataset

.trg.dataset

Map Editor

Text Editor

JSON Editor (default)

Map

Transformation of a source file or table. Includes field-to-field mapping, and event actions and conditional expressions to manipulate data.

.map

.map.xml*

Map Editor

Text Editor

JSON Editor

XML Editor*

Map Runtime

A file containing all of the runtime information related to a map. Tis includes the source and target connections, logging information, macro sets and macro overrides. Most of the runtime content is found on the Map Editor source, target and configuration tabs.

.map.rtc

.tf.xml*

Map Editor

Text Editor

JSON Editor

XML Editor*

Process

Workflow that includes steps for maps, scripts, application executables, and components.

.process

.ip.xml*

Process Editor

Text Editor

JSON Editor

XML Editor*

Process Runtime

A file containing all of the runtime information related to a process. This includes any transformation, macrosets and macro overrides. Most of the runtime content is found on the Process Editor configuration tab.

.process.rtc

.ip.rtc (optional)

Process Editor

Text Editor

JSON Editor

XML Editor*

Schema

The arrangement of fields in a record in a data file, either source or target. This includes field length, record length, field data types, and other field properties, such as decimal and scale.

.schema

.ss.xml*

.ds.xml*

Schema Designer

Text Editor

JSON Editor (default editor for .schema files)

XML Editor*

Script Library

Reusable, user written functions and expressions.

.ezscript

.rifl*

.bas*

Script Editor

Text Editor

JSON Editor

XML Editor*

Package

A deployment package is an archive file that contains all the artifacts that are required to run a process or map. The format of a package is a .djar file. There is a DataConnect preference that can be set for the default location of deployment packages.

.djar

Package Manager

Package Inventory

A list of the files and other options included in a package. The document is a design-time only document, created to facilitate recreating a new package with updated artifacts.

.inv

Package Manager

Text Editor

XML Editor*

Profile

An engine profiling output file. Profiling can be turned on for any map or process to help find integration performance problems. Profiling options can be found on the Configuration tab in the Map or Process Editor.

.out

Engine Profiler

SQL File

 

Contains reusable SQL query code or code that is used to modify the contents of an associated database, such as the statements, that are needed to create or modify the structure of the database.

.sqlquery

Map Editor

Test Editor

Session

 

A reusable database session part container. Can be used to share a single database session between multiple process steps.

.session

Process Editor

JSON Editor (default)

*Document Schema

An electronic document schema that conforms to the various industry standards for defining financial (SWISS), health care (HIPAA, HL7), and e-commerce (EDI) interchanges.

.ds.xml*

Schema Designer

Text Editor

XML Editor*

Extract

 

Contains the data that must be extracted from semi-structured text files and convert the data into a tabular format that can be used as a source in Map Editor.

.extract

Content Extractor Editor