In TIBCO Scribe® Online or TIBCO Cloud Integration - Connect, there is no mechanism for encoding and decoding information, adding custom messages to the Agent log, or pausing a Map/flow. In addition, the requirement of a Query Block can be limiting depending on what you are trying to accomplish.Using the Query Block with the Tools SelectOne entity only returns one record with a datetime. By using the SelectOne entity to start the Map/flow, you can use Fetch Blocks to create sub-queries. For example, if you wanted to integrate Accounts and Customers into a Microsoft SQL Server database, you could do that within two Fetch Blocks. You can use these Maps/flows to learn about Debug also.

These simple Maps/flows attempt to demonstrate some of these concepts and how they can be achieved using the Tools Connector. Each Block in the Maps/flows has a brief description that explains the purpose of that Block.

The Change the way maps process Map/flow demonstrates the following:

• Starting a Map/flow with no source data for the Query Block.
• Using Fetch Blocks to return and process different sets of data.
• Executing a Sleep timer to pause the Map/flow.

The Adding custom logging and errors Map/flow demonstrates the following:

• Mapping dynamic values to the Agent logs.
• Mapping a dynamic value as a Fatal Error message.
• Mapping a dynamic value as a Record Error message.

Note that these are not real errors they are just demonstrating error logging.

The Encoding and converting values Map/flow demonstrates the following:

• Converting a DateTime to UNIX/Epoch.
• Encoding a value to Base64 .
• Decoding a Base 64 value.
• Encoding a value to SHA1.

The Converting String <-> Byte Array Map/flow demonstrates the following:

• Creating a variable for storing a CSV object and populating it.
• Converting a string to a byte array.
• Converting a byte array to a string.

Scribe Online Classic Users
For more information on prerequisites, importing the Maps, and using the Tools Connector, see Connector Extensions and Tools Connector.

TIBCO Cloud Integration - Connect Users
For more information on prerequisites, importing the Maps, and using the Tools Connector, see Connector Extensions and Tools Connector.
 

DISCLAIMER

 

Copyright (c) 2020, TIBCO Software Inc. All rights reserved.

 

No Support. You acknowledge that TIBCO will not provide any maintenance or support for this software. You have no right to receive any upgrades, patches, enhancements, bug fixes, new versions or new releases of the software.

 

Internal Use Only License Grant. TIBCO hereby grants you a limited, non‐transferable, non‐exclusive license to use the software solely for your internal business purposes. The name of TIBCO Software Inc. may not be used to endorse or promote products derived from this software without specific prior written permission of TIBCO Software Inc.

 

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT OWNERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.  

Use the attached Sample Map to familiarize yourself with using the Tools Connector Extension.