TIBCO Scribe® Online Connector For Tools

The TIBCO Scribe® Online Connector For Tools provides special operations used as entities in the Query, Fetch, and Execute Blocks in your TIBCO Scribe® Online Maps to enhance the performance of the Map, functions, or provide diagnostic information.

Connector Specifications

	Supported
Agent Types
On Premise	X
Cloud	X
Replication Services
Source
Target
Integration Services
Source	X
Target	X
Migration Services
Source	X
Target	X
Maps
Integration	X
Request-Reply	X
Message	X

Supported Entities

The Tools Connector supports the following entities. Click a linked entity name for additional information when using that entity in TIBCO Scribe® Online. For a list of additional operations by entity see Special Operations.

Special Operations

Entity	Operations
SelectOne	-Query -Fetch -Lookup
Base64Decode Base64DecodeToBytes Base64Encode Base64EncodeToBytes Dates FatalError Hash Functions HMAC RowError Sleep WriteLog	-Execute

Selecting An Agent Type For Tools

Refer to TIBCO Scribe® Online Agents for information on available Agent types and how to select the best Agent for your Solution.

This Connector supports both the Cloud Service and the On-Premise Agent for the supported Solution types listed in the Connector Specifications table, regardless of the location of the data. Data can be in the cloud or on-premises. See Installing A TIBCO Scribe® Online On-Premise Agent or Provisioning A TIBCO Scribe® Online Cloud Service.

Connecting To Tools

1. Select More > Connections from the menu.
2. From the Connections page select Add to open the Add a New Connection dialog.
3. Select the Connector from the drop-down list in the Connection Type field, and then enter the following information for this Connection:
   • Name — This can be any meaningful name, up to 25 characters.
   • Alias — An alias for this Connection name. The alias is generated from the Connection name, and can be up to 25 characters. The Connection alias can include letters, numbers, and underscores. Spaces and special characters are not accepted. You can change the alias. For more information, see Connection Alias.
4. Select Test to ensure that the Agent can connect to your database. Be sure to test the Connection against all Agents that use this Connection. See Testing Connections.
5. Select OK/Save to save the Connection.

Tools Connector As IS Source

Consider the following when using the Tools Connector as an Integration Solution source.

• Net Change is not supported.

Notes On Entities And Operations

Base64Decode

Converts a Base64 encoded String to an un-encoded String.

• Base64Decode has one input property, DecodeInput.
• A NULL or empty DecodeInput value skips the block completely.
• An invalid DecodeInput value results in the record error.

DecodeOutput is an output property, used to convert your input base64 encoded string to its String value. This function works similar to the decode tool at the BASE64 Decode and Encode site. A common use-case would be to validate base64 encoded values.

Base64DecodeToBytes

Converts a string to Bytes.

• Base64DecodeToBytes has one input property, DecodeInput.
• A NULL or empty DecodeInput value skips the Block completely.
• An invalid DecodeInput value results in a record error.

Base64EncodeToBytes

Converts Bytes to a string.

• Base64EncodeToBytes has one input property, EncodeInput.
• A NULL or empty EncodeInput value skips the Block completely.
• An invalid EncodeInput value results in a record error.

Base64Encode

Converts a String to Base64, ISO-8859-1 encoded string.

• Base64Encode has one input property, EncodeInput.
• A NULL or empty EncodeInput value skips the Block completely.
• An invalid EncodeInput value results in record error.

EncodeOutput is an output property, used to convert your input string to a base64 encoded value. This function works similar to the encode tool at the BASE64 Decode and Encode site. Common use-cases with this function might be to send a username and password, or clientId and clientSecret in an HTTP header - also known as Basic Authentication. Refer to the Basic access authentication page on Wikipedia for more information.

Dates

Converts a DateTime to other formats.

• Dates has one input property, InputDate.
• A NULL or empty InputDate value skips the Block completely.
• An invalid InputDate value results in record error.

Unix is an output property, used to convert your DateTime value into a Unix value, also known as POSIX or UNIX Epoch time. The function works in a way that is similar to the following tool: Epoch Converter. A common use-case for this function is to send an HTTP date header or append to a file name.

FatalError

Supports adding a custom message with a dynamic value to the error details when a Fatal Error occurs. Use this option to include data from the Map in your error message for better troubleshooting. For example, you might choose to include an account number to help locate a source record that is generating an error. This message is not affected by the settings on the Block Properties Error Handling tab.

Hash Functions

Supports the following functions:

• SHA1
• SHA256
• SHA384
• SHA512

These functions are cryptographic hash functions that take an input and produce a (string) hash value as the output.

• Each function has one input property, InputString.
• A NULL or empty InputString value skips the block completely.

OutputHash is an output property used to convert your input to the selected encoded Hash value. These functions work similar to the hash function online generator at http://www.sha1-online.com/. This is a one-way hash encoding process, there is no decoding. Common use-cases include hashing for pseudonymisation in GDPR and comparing hashed passwords, such as incoming Request/Reply and Message Maps with Hashed passwords, and known passwords stored in TIBCO Scribe® Online Maps/Lookup Tabs.

HMAC

HMAC is supported by using the SHA1, SHA256, SHA384, and SHA512 hash functions.

• Each function has one input property, InputString with an optional key, InputKey.
• A NULL or empty InputString value skips the block completely.
• Output types include: Byte Array, String(50), and Base64Encoded String.

OutputBase64, OutputBytes, and OutputString are output properties used to convert your input to the selected encoded Hash value. A common use case is for creating API/Web Service authorization signatures.

RowError

Supports adding a custom message with a dynamic value to the error details when a record error occurs. Use this option to include data from the Map in your error message for better troubleshooting. For example, you might choose to include an account number to help locate a source record that is generating an error. To generate this error message, error handling must be enabled on the Error Handling tab of the Execute Block. If error handling is disabled, the custom message is not generated. If error handling is enabled, both the message on the Error Handling tab and the custom message are generated and are included in the Execution History Error Details.

SelectOne

• This entity is supported for the Query, Fetch, and Lookup Blocks.
• When used in a Query Block: 
  • Provides the ability to start a Map without querying a data source.
  • Always returns the current time in UTC.
  • Filters are not supported.

You can use the SelectOne entity to start a Map without running a query in cases where you would really prefer to use a Fetch Block to gather data. For example, your Map might use SelectOne in a Query to start, then use a REST Connector CreateWith Block and then a Fetch Block to provide data for an Add Block to build a hierarchical record.

Sleep

Use the Sleep entity in an Execute Block to add a delay in a Map.

• Sleep has one property, SleepTime, which suspends the current thread for the specified number of milliseconds.
• Internally the SleepTime parameter is millisecondsTimeout.
• SleepTime must range from 0 to 60,000 ms.
• A NULL or empty SleepTime value skips the Block completely. An invalid SleepTime value results in record errors.

WriteLog

Use WriteLog in an Execute Block to add an entry into the Agent Log when the Block is encountered in the Map. WriteLog allows you to configure the log level where you want to add the entry. For example, to only log when the Agent is set to Warning, the Severity should be set to 2. You can add additional detail to the Agent log entry up to 2048 characters using the Message field.

The Agent log includes messages similar to the following: 

Sample Maps

In TIBCO Scribe® Online, there is no mechanism for encoding and decoding information, adding custom messages to the Agent log, or pausing a Map. 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, 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 to learn about Debug also.

These simple Maps attempt to demonstrate some of these concepts and how they can be achieved using the Tools Connector. Review the Block descriptions in the Maps that explain the purpose of the associated Block.

The Change the way maps process Map demonstrates the following: 

• Starting a Map 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.

The Adding custom logging and errors Map 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 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 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.

TIBCO Scribe® Online API Considerations

To create connections with the TIBCO Scribe® Online, the Tools Connector requires the following information:

Connector Name	Tools
Connector ID	EB930ED7-CFDB-479F-8EFB-70BDB4AC6EA8

License Agreement

The TIBCO Scribe® Online End User License Agreement for the Tools Connector describes TIBCO and your legal obligations and requirements. TIBCO suggests that you read the End User License Agreement.

More Information

For additional information on this Connector, refer to the Knowledge Base and Discussions in the TIBCO Community.