Wednesday, 1 July 2015

DELL BOOMI ATOMSPHERE

The main component in Dell Boomi AtomSphere is the process. A process represents a business process- or transaction-level interface between two systems. Examples of a process might be "Salesforce Account Synchronization to a legacy accounting system" or "Sales Orders from Company ABC to QuickBooks." Processes contain a left-to-right series of shapes connected together like a flow chart to illustrate the steps required to transform, route and otherwise manipulate the data from source to destination.

Processes use connectors to get and send data. Every process begins with the Start shape (containing the inbound connector) on the left. A process can have any number of execution and logic shapes within it. A process typically ends with one or more outbound connectors on the right.

Profiles represent the structure and format of the source and destination data. The following types of profiles are available: Database, EDI, Flat File, XML and JSON. A process typically contains one or more maps along the way that transform the source profile into the destination profile.

When a process is executed, the inbound connector in the Start shape retrieves its data (for example: performs an FTP GET, executes a database SELECT query or invokes a web service call) and passes the resulting data into the process as one or more documents. Documents move through the process steps sequentially, where each shape performs a specific task on the data and then passes it onto the next shape.

DBT - Models

Models are where your developers spend most of their time within a dbt environment. Models are primarily written as a select statement and ...