Getting Started with TIBCO® Data Virtualization on AWS

Table of Contents

• Getting Started with TIBCO® Data Virtualization on AWS
  • Community Resources and Doc Links
  • First Steps for Configuring your TDV Instance
  • Studio Development Environment
  • Installing Business Directory
  • Client Drivers
• Security Considerations
  • TDV Port Definitions
  • How to open inbound ports for TDV client access on your TDV AWS instance
  • Write permission error when installing/copying files to /opt
  • Internet Explorer 11 trusted site restriction

Getting Started with TIBCO® Data Virtualization on AWS

Welcome! There are a number of community resources to get you up and running with TIBCO® Data Virtualization (TDV).  If you go to the below docs link, there is a Getting Started guide for how to do just that. There is also an Admin guide to walk you through more advanced tasks like setting up a cluster.

Community Resources and Doc Links

Docs: https://docs.tibco.com (Register and search for ?Data Virtualization?)

TDV Community Wiki (registration required)

Idea Portal: https://ideas.tibco.com/?project=TDV (Register for community first)

Increase the Value of Your Cloud Data with Better Data Virtualization Ebook (download below)

First Steps for Configuring your TDV Instance

The Web Manager console can be used to configure your instance by going to the following URL: http://<TDV hostname or IP>:<port>/manager.  The default login is admin/<instance-ID>. You can go to configuration > cluster to configure or add a new cluster node.

Studio Development Environment

The TDV Studio development environment is installed with the Windows AMI. For the Linux AMI, you will need to download Studio and install it on a windows desktop. There are instructions for how to do this in the install guide.

Installing Business Directory

Business Directory is not installed by default in either the Linux or Windows AMIs.  The installation executable is included with the AMI. To install, follow these steps:

1. For linux platform only, run sudo chmod 777 /opt before installation.
2. Run the TDV Business Directory (BD) installer binary (.exe for windows, .bin for Linux)
   1. Note: replace 7.0.7 with the latest version of TDV Business Directory if one exists.
   2. Windows location: C:\Program Files\Tibco\Downloads\bd\TIB_tdv_bd_7.0.7_win_x86_64.exe
   3. Linux location: /opt/Tibco/downloads/bd/TIB_tdv_bd_7.0.7_linux_x86_64.bin
3. During the installation of TDV Business Directory, take note of your repository admin password and server base port (default 9500).  
4. Modify your TDV AWS instance's security to the group to add the following BD ports 9500 (non ssl port) and 9502 (ssl port).
   1. See "linux BYOL with BD security group example.png" or "windows BYOL with BD security group example.png."
   2. If you don't know how to change your TDV AWS instance's security group please find the following TDV content titled "How to open inbound ports for TDV client access on your TDV AWS instance.?
5. For Windows platform only, you will need to add a custom inbound rule on the Windows OS itself.
   1. Open Administrative Tools -> Control Panel -> System and Security -> Administrative Tools -> Windows Firewall with Advanced Security.
   2. Click on "Inbound Rules" in the "View and create firewall rules" section of "Windows Firewall with Advanced Security on Local Computer."
   3. Click on "New Rule..." in the "Actions - Inbound Rules" section on the right hand side.
   4. Select "Port" in the "New Inbound Rule Wizard" and click "Next" button.
   5. Select "TCP" and "Specified local ports:" with a value of "9500,9502" then click "Next" button.
   6. Select "Allow the connection" and click "Next" button.
   7. Accept defaults to apply to Domain, Private and Public options and click "Next" button.
   8. Create a name and description for your new inbound rule.
   9. After rule is created, double click on your new inbound rule and select "General" tab to make sure your rule is enabled.
   10. Select "Protocols and Ports" tab to double check your ports 9500 and 9502 are allowed.
6. From a non-AWS instance, open a browser client (Firefox or Chrome), go to http://<TDV AWS IP or external hostname>:9500/directory or https://<TDV AWS IP or external hostname>:9502/directory.
7. Unlike the TDV server password being your TDV AWS Instance ID, the default user password will be "admin".  Please change this to a more secure password after installation. User "admin" and password "admin" for the BD login is the default user/password configuration after BD installation when running the BD installer.

    

    

Client Drivers

Client drivers are required for client applications to connect to the TDV Server (or Cluster).  The drivers are located in C:\Program Files\Tibco\Downloads\client\TIB_tdv_drivers_7.0.7_all.zip  (Windows) and /opt/Tibco/downloads/client/TIB_tdv_drivers_7.0.7_all.zip (Linux).  

For the ADO.NET driver, the .NET framework needs to be installed on the machine with the driver.

Note: ADO.NET driver prerequisites can be found at https://docs.tibco.com/pub/tdv/7.0.7/doc/pdf/TIB_tdv_7.0.7_ClientInterfacesGuide.pdf (pages 97-98).

Security Considerations

TDV Port Definitions

As a standalone installation TDV only requires ports 9400 - 9403 (assuming you pick the default base port 9400).

If you want to run TDV in a cluster configuration then you need to additionally open up port 9407 for communication to work between TDV cluster nodes.

• 9400: Web services HTTP port
• 9401: JDBC, ODBC, ADO.NET port
• 9402: Web services HTTP SSL port
• 9403: JDBC SSL, ODBC SSL and ADO.NET SSL port
• 9407: Active Cluster port

For Business Directory installations only the base port (default 9500) needs to be opened up.

Notes:

1. "Opened up" basically means you have an inbound rule for a port or port range in your TDV AWS instance's security group.
2. See below screenshots for Window and Linux examples of a correctly configured TDV AWS instance's list of inbound rules.

Linux:

Windows:

How to open inbound ports for TDV client access on your TDV AWS instance

Note: If you launch the TDV AMI with the seller's security recommendations then you don't need to perform these steps.

The example below shows how to open up the standard TDV ports 9400-9403 and 9407.         

For Windows platforms, please follow step #5 in the "How to install TDV Business Directory on a TDV AWS instance" content since the Windows platform requires OS-level firewall changes to get port changes to work after you launch a new TDV AWS instance.

1. Login to your AWS account.

2. Select the EC2 service.

3. Select Network & Security in the EC2 Dashboard.

4. Select Security Groups.

5. Find and select the security group you used for launching the TDV AWS instance.

6. Select the Inbound tab for that security group.

7. Click Edit.

8. Click Add Rule.  

9. Add the following:

   -Type="Custom TCP Rule"

   -Protocol="TCP"

   -Port Range="9400-9403"

   -Source=Custom 0.0.0.0/0

10. Add the following (if you are setting up a cluster of TDV instances):

   -Type="Custom TCP Rule"

   -Protocol="TCP"

   -Port Range="9407"

   -Source=Custom 0.0.0.0/0

11. Click Save.

Write permission error when installing/copying files to /opt

To avoid a write permission error under /opt, please run sudo chmod 777 /opt before running another TDV installer or applying future patch/hotfix files to any TDV installations under /opt.

Internet Explorer 11 trusted site restriction

On the TDV AWS instance (Windows platform only), if you launch the Internet Explorer 11 browser then you will may add the site you are trying to access as a trusted site.

1. Open Internet Explorer 11 browser from C:\Program Files
2. Open the Internet Explorer options and add the current web address manually to trust site (e.g. https://<TDV_AWS_IP_or_hostname>:9402/manager)

NOTE: The IE 11 client browser has not been certified for the TDV 7.0.7 release.  So it is recommended to install another supported browser client on your TDV AWS Windows instance instead.  See which browsers are supported by going to page 20 ?Web Browser Support? at https://docs.tibco.com/pub/tdv/7.0.7/doc/pdf/TIB_tdv_7.0.7_InstallationGuide.pdf.

TIBCO Data Virtualization_ Increase the Value of Your Cloud (AWS).PDF