Top 10 FREE useful tools for Fusion Consultants

This is one of the most frequently used tool and most of you are also aware of it. This is basically a text editor with some syntax highlighting for SQL, XML etc.

What most of you don’t know is you can enhance the functionality of Notepad++ with the help of plugins available. List of official NPP Plugins are available here

The ones that I use are:
DSpellCheck > Spell checker to check typos.
Mime Tools > To convert text to Base64 encode and Decode without having to go online and convert.
XML Tools > To Convert the XML File into pretty readable format and find out the XPATH of the node that we are interested in.

This is not an online tool. You will have to download and install it on your local machine to use it.

2. SOAPUI

https://www.soapui.org/

This is one of the widely used tools to test the SOAP/REST services. You can save the sample payloads as projects, so whenever you open the tool, you can reload the settings and use it directly. The UI is user friendly and it is easy to use. This is not an online tool and you will have to download and install it on your local machine.

3. SQL Formatter

http://www.dpriver.com/pp/sqlformat.htm

We can convert the SQL written in random format into a neat and clean format with spacing for the select fields, from clause and where clause so that we can literally read through the SQL Query from top to bottom. There are multiple options that you can use too at the right hand side. This is an online only tool and no installation required.

4. Text Compare

https://text-compare.com/

This tool is used for comparing two files and it provides the differences beautifully. It will be useful to compare changes to the query or formula with respect to the backup copy. This is an online only tool and no installation required.

5. Base64 Encode and Base64 Decode

Encode – https://www.base64encode.org/
Decode – https://www.base64decode.org/

These tools are mostly used when we use web services to get the output of BI Report and want to decode it or want to upload a file to UCM using web services. This is an online only tool and no installation required.

6. Text Tools

https://miniwebtool.com/text-tools/

There are set of text tools available on this website which can be used as per our convenience.

Add Prefix and Suffix, Sort Alphabetically, Remove lines containing, remove duplicate lines to name a few.

This is an online only tool and no installation required.

7. Text to HTML

https://www.textfixer.com/html/convert-text-html.php

This tool can be used to convert Text to HTML. In some data conversions, we have a requirement to load the data in html format so that the end user sees the formatted code. We can use this online tool to convert to html and then add the code to a text file and upload it using HDL.

This is an online only tool and no installation required.

8. XSLT transformation

https://www.freeformatter.com/xsl-transformer.html

In some cases when you use XSL templates for BI Reports or HCM Extracts, you need to test the XSL template. The only way to test this XSL template is to use the XSL Transformation websites. This is one of them. They have lot of other online tools too. You need to upload the input XML, XSL template and then it will generate the output XML for you. This is an online only tool and no installation required.

9. Code Beautify

https://codebeautify.org

This website has lot of text formatting tools, Base64 Decoder, Encoder, JSON Formatter, XML Viewer, XML Validator, XML to JSON,etc.

You can use these when you use SOAP/REST services and need tools to prepare payload in the right format. This is an online only tool and no installation required.

10. Convert Case

https://convertcase.net/

This website has host of features on text tools. converting text to lowercase, uppercase, alternating case, title case, word count, character count and line count. This is an online only tool and no installation required.

Do you use any other free tools which you think would help others? Post them in the comments section.