Boomi Tools

Notepad++ Macros

To view Database output, two macros are available and allow you to:

  1. View Data: separate the information formatted by the Database profile to view the Dell Boomi technical information and the Database data
  2. View in Excel: format the information from the Database profile to have a view in Excel

Installation

Download shortcuts.xml and copy the file your %appdata%\Notepad++ folder and restart Notepad++

Steps

Execute a process or use process reporting to locate a DB operation which return data formatted in Database Profile.

DB_Process

Execute the process

DB_Process_Executed

Download or copy the document

DB_Process_Data

Paste or open the document in Notepad++

Notepad_data

Select one the of the Dell Boomi Macros in Notepad++

Notepad_macro

You will get the formatted data

Notepad_macro_out

And you can copy/paste it to Excel

Excel_data