TIBCO(R) Data Virtualization

Note

This connector is owned and provided by TIBCO.

Summary

Property Value
Connector TIBCO(R) Data Virtualization icon TIBCO(R) Data Virtualization
Products Power BI (semantic models)
Power Query Online
Release state General availability
Category Database
Authentication kinds Anonymous
Basic
Windows
Data source kind TibcoTdv
Function Reference Documentation TibcoTdv.DataSource
Support link Contact the connector owner.

Prerequisites

To access the TIBCO eDelivery site, you must purchase TIBCO software. There's no TIBCO license required for the TIBCO(R) Data Virtualization (TDV) software—a TIBCO customer only needs to have a valid contract in place. If you don't have access, then you need to contact the TIBCO admin in your organization.

The Power BI Connector for TIBCO(R) Data Virtualization must first be downloaded from https://edelivery.tibco.com and installed on the machine running Power BI Desktop. The eDelivery site downloads a ZIP file (for example, TIB_tdv_drivers_<VERSION>_all.zip*.zip where <VERSION>=TDV Version) that contains an installer program that installs all TDV client drivers, including the Power BI connector.

Screenshot of the TDV installation setup dialog.

Once the connector is installed, configure a data source name (DSN) to specify the connection properties needed to connect to the TIBCO(R) Data Virtualization server.

Note

The DSN architecture (32-bit or 64-bit) needs to match the architecture of the product where you intend to use the connector.

Screenshot of the TDV DSN Configuration dialog.

Note

Power BI Connector for TIBCO(R) Data Virtualization is the driver used by the TIBCO(R) Data Virtualization connector to connect Power BI Desktop to TDV.

Supported capabilities

  • Import
  • DirectQuery (Power BI semantic models)
  • Advanced Connection Properties
  • Advanced
    • Native SQL statement

Parameters

Entry point: TibcoTdv.DataSource

Required parameter count: 1

Parameter Display name Required Type Group Sample values Nullable
dsn Data Source Name (e.g. Power BI TDV) Yes text "Power BI TDV" false
advancedOptions Advanced Connection Properties No nullable text "PropertyA=Value1;PropertyB=Value2;" true
options Advanced Options No nullable record Advanced Options true

Fields in options

Field Display name Required Type Group Declared default Sample values Nullable Optional
options.Query SQL statement - not supported with DirectQuery No text Advanced Options "" "SELECT * FROM <Table>" false true

Connect from Power Query Desktop

Once the matching connector is installed and a DSN is configured, you can connect to a TIBCO(R) Data Virtualization server. To make the connection, take the following steps:

  1. Select the TIBCO(R) Data Virtualization option in the connector selection.

  2. In the Power BI Connector for TIBCO(R) Data Virtualization dialog that appears, provide the Data Source Name.

    Screenshot of the TDV connection builder in Power BI.

  3. Select either the Import or DirectQuery data connectivity mode.

  4. If you're connecting to this database for the first time, select the authentication type. If applicable, enter the needed credentials. Then select Connect.

    • Anonymous: Uses the credentials stored in the DSN.
    • Basic: Username/password are submitted when creating the connection.
    • Windows: Authenticates using the current Windows user. This authentication type requires the SSO connection property to be set. When you use Kerberos, the Use Platform Kerberos API must be set to true to use the current Windows user.

    Screenshot of the TDV authentication dialog where you enter your credentials.

  5. In Navigator, select the database information you want, then either select Load to load the data or Transform Data to continue transforming the data in Power Query Editor.

    Screenshot of the Power Query Desktop Navigator showing the product data in TDV.

Additional information

Advanced options

Power Query Desktop provides a set of advanced options that you can add to your query if needed.

The following table lists all of the advanced options you can set in Power Query Desktop.

Advanced option Description
Advanced Connection Properties Takes a semi-colon separated list of connection properties. This option is used to specify other connection properties not configured in the DSN.
SQL statement For information, go to Import data from a database using native database query.

Once you select the advanced options you require, select OK in Power Query Desktop to connect to your TIBCO(R) Data Virtualization Server.

Kerberos-based single sign-on (SSO) for TIBCO(R) Data Virtualization

The TIBCO(R) Data Virtualization connector now supports Kerberos-based single sign-on (SSO).

To use this feature:

  1. Sign in to your Power BI account, and navigate to the Gateway management page.

  2. Add a new data source under the gateway cluster you want to use.

  3. Select the connector in the Data Source Type list.

  4. Expand the Advanced Settings section.

  5. Select the option to Use SSO via Kerberos for DirectQuery queries or Use SSO via Kerberos for DirectQuery and Import queries.

    Screenshot of the Add data source dialog showing the Kerberos advanced settings in TDV.

For more information, go to Configure Kerberos-based SSO from Power BI service to on-premises data sources.

  • Last updated on