• Post category:Others
  • Post comments:1 Comment
  • Post last modified:June 12, 2020
  • Reading time:4 mins read
You are currently viewing Top 10 FREE useful tools for Fusion Consultants
Top 10 FREE useful tools for Fusion Consultants
- Top 10 FREE useful tools for Fusion Consultants
Total Visits: 35

In this article we will look into the tools that make life easier for Fusion consultants on daily work schedules.

1. Notepad++

https://notepad-plus-plus.org/downloads/

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.

notepad - Top 10 FREE useful tools for Fusion Consultants
Notepad++ Plugins Admin

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.

soapui 1024x650 - Top 10 FREE useful tools for Fusion Consultants
SOAPUI tool

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.

SQL Formatter 1024x748 - Top 10 FREE useful tools for Fusion Consultants
Formatting SQL Query easily

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.

textcompare 1024x417 - Top 10 FREE useful tools for Fusion Consultants
Text Compare Online tool

5. Base64 Encode and Base64 Decode

Encodehttps://www.base64encode.org/
Decodehttps://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.

encode decode - Top 10 FREE useful tools for Fusion Consultants
Base64 decode and encode online tool

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.

text tools - Top 10 FREE useful tools for Fusion Consultants
Text tools online tool

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.

texttohtml - Top 10 FREE useful tools for Fusion Consultants
Text to HTML

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.

xsltransformation 1024x498 - Top 10 FREE useful tools for Fusion Consultants
XSL Transformation online

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.

codebeautify 1024x411 - Top 10 FREE useful tools for Fusion Consultants

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.

convertcase 1024x396 - Top 10 FREE useful tools for Fusion Consultants

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

  • In visible box by plugintheme