Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Edge Data Streaming
  3. Licenses
  4. Using Informatica Administrator
  5. Creating and Managing the Edge Data Streaming Service
  6. Edge Data Streaming Entity Types
  7. Edge Data Streaming Nodes
  8. Data Connections
  9. Working With Data Flows
  10. Managing the Edge Data Streaming Components
  11. Security
  12. High Availability
  13. Disaster Recovery
  14. Monitoring Edge Data Streaming Entities
  15. Appendix A: Troubleshooting
  16. Appendix B: Frequently Asked Questions
  17. Appendix C: Regular Expressions
  18. Appendix D: Command Line Program
  19. Appendix E: Configuring Edge Data Streaming to Work With a ZooKeeper Observer
  20. Appendix F: Glossary

User Guide

User Guide

Creating the Edge Data Streaming Service in the Administrator Tool

Creating the Edge Data Streaming Service in the Administrator Tool

Create the Edge Data Streaming Service in the Manage tab in Administrator tool and create, manage, deploy and undeploy, and monitor data flows.
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
    Edge Data Streaming Service
    .
    The
    New Edge Data Streaming Service
    window appears.
  3. Enter the following general properties for the service:
    Name
    Name of the Edge Data Streaming 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
    EDS
    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
    EDS
    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>;ServiceName=<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 Edge Data Streaming 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
    Edge Data Streaming
    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!