Table of Contents

Search

  1. Preface
  2. Installation and Configuration
  3. Pre-Installation Tasks
  4. Installation
  5. Post-Installation Tasks
  6. Uninstallation
  7. Troubleshooting the Installation
  8. Configuring Extended JVM Parameters
  9. Glossary

Installation and Configuration Guide

Installation and Configuration Guide

Creating the Vibe Data Stream Service

Creating the
Vibe Data Stream
Service

Create the
VDS
Service in the
Administrator tool
.
Start the
Administrator Daemon
and Apache ZooKeeper before you create the service.
  1. In the
    Administrator tool
    , click the
    Services and Nodes
    tab.
  2. Click
    Actions
    New
    Vibe Data Stream Service
    .
    The
    New Vibe Data Stream Service
    window appears.
  3. Enter the following general properties for the service:
    Name
    Name of the Vibe Data Stream Service. The name is not case sensitive and must be unique within the Informatica domain. The characters must be compatible with the code page of the associated repository. The name cannot exceed 128 characters or begin with @. It also cannot contain spaces or the following special characters:
    ` ~ % ^ * + = { } \ ; : ' " / ? . , < > | ! ( ) ] [
    Description
    Description of the service. The description cannot exceed 765 characters.
    Location
    Name of the Informatica domain and folder where you want to create the service. Optionally, click
    Browse
    to select another folder in the Informatica domain.
    License
    License assigned to the service. Select from the list of
    VDS
    licenses available.
    Assign
    Node on which the service runs. Select
    Single Node
    to assign the service to a node.
    Node
    The host name or machine name where the service runs.
  4. Click
    Next
    .
  5. Enter the following database properties for the service:
    Database Type
    The type of database that contains the
    VDS
    repository.
    You can select one of the following databases:
    • DB2
    • Oracle
    • SQLServer
    • Sybase
    Kerberos Authentication
    Indicate that the database uses Kerberos authentication. This option is supported only for SQLServer.
    Username
    The database user.
    Password
    Database password corresponding to the database user.
    JDBC Connect String
    The connection string used to connect to the database.
    • IBM DB2.
      jdbc:informatica:db2://<host name>:<port>;DatabaseName=<database name>
    • Microsoft SQL Server.
      Server: jdbc:informatica:sqlserver://<host name>:<port>;DatabaseName=<database name>
    • Kerberos-enabled Microsoft SQL Server.
      jdbc:informatica:sqlserver://<host name>:<port>;DatabaseName=qadb;integratedSecurity=true;authenticationScheme=JavaKerberos;encrypt=false
    • Oracle.
      jdbc:informatica:oracle://<host name>:<port>;ServceName=<service name>
    • Sybase.
      jdbc:informatica:sybase://<host name>:<port>;DatabaseName=<database name>
    Secure JDBC Parameters
    Secure JDBC parameters that you want to append to the database connection URL.
    Use this property to specify secure connection parameters such as passwords. The Administrator tool does not display secure parameters or parameter values in the Vibe Data Stream Service properties. Enter the parameters as name=value pairs separated by semicolon characters (;). For example:
    param1=value1;param2=value2
    If secure communication is enabled for the database, enter the secure JDBC parameters in this property.
    Database Schema
    The schema name for the Microsoft SQL Server database.
    Database Tablespace
    Tablespace name for IBM DB2 database. When you specify the tablespace name, the
    Vibe Data Stream
    Service creates all repository tables in the same tablespace. You cannot use spaces in the tablespace name.
  6. Click
    Test Connection
    to verify if the connection to the database is successful.
  7. Click
    Finish
    .

0 COMMENTS

We’d like to hear from you!