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

This Connector is available from the TIBCO Scribe® Online Marketplace. See Marketplace TIBCO Scribe® Certified Connectors for more information.

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 Agent 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 Agent.

Note: If you use a Cloud Agent with an on-premise datastore, you may need to whitelist the IP addresses of the Cloud Agent managers to allow the Cloud Agent to access your network. See Whitelisting Requirements.

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 to save the Connection.

Tools Connector As IS Source

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

Notes On Entities And Operations

Base64Decode

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

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.

Base64EncodeToBytes

Converts Bytes to a string.

Base64Encode

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

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.

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:

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

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.

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

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.

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.

Note: Requires that Debug be enabled on the Agent. See Editing Agent Settings for instructions on enabling Debug.

The Agent log includes messages similar to the following: 

Sample Maps

Note: To download the Sample Maps go to the Tools Sample Maps Knowledge Base article in the TIBCO Community

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: 

The Adding custom logging and errors Map demonstrates the following: 

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

The Encoding and converting values Map demonstrates the following: 

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

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.