Samples for Tools Connector

In TIBCO Cloud? Integration - Connect, there is no mechanism for encoding and decoding information, adding custom messages to the agent log, or pausing a 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 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 flows to learn about Debug also.

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

Prerequisites

You can import the Sample App from the marketplace listing by searching for Samples for Tools Connector and selecting Get. You will also need to Install the other prerequisite Connectors (if not installed already):

• Sample - CRM Connector and an associated Connection named SampleCRM with no spaces or special characters. On the Connection Configuration dialog set the Use Sample Data field to true to use the sample data distributed with the Connector. See the Sample CRM Connector section below for more details.
• Tools Connector and an associated Connection named Tools.
• Variables Connector and an associated Connection named Variables. 

If Connection names do not match the names specified in the prerequisites, you will have to reassign the Connections in the Sample Flows after you import them.

Sample CRM Connector 

Note the following when using the Sample CRM Connector:

• A sample database is installed in the agent folder when the Connector is installed.
• If you have more than one Connect on-premise agent installed, there is a separate database for each agent. In this case, the database associated with the agent that runs an app using the Sample CRM Connection is the database that is updated. If you have multiple agents, you can expect the databases to be different over time.
• If you are using a Connect cloud agent, there is a separate database for each app that uses the Connect cloud agent. In this case, you can expect the database for each app to be different over time.

Change the way flows are processed 

This flow demonstrates the following: 

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

Add Custom Logging and Errors in a Flow 

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

Encoding and Converting Values 

This flow demonstrates the following: 

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

Converting between a String and Byte Array 

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

DISCLAIMER 

Copyright © 2022, 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.