Table of Contents

Search

  1. Preface
  2. Understanding Domains
  3. Managing Your Account
  4. Using Informatica Administrator
  5. Using the Domain View
  6. Domain Management
  7. Nodes
  8. High Availability
  9. Connections
  10. Connection Properties
  11. Schedules
  12. Domain Object Export and Import
  13. License Management
  14. Monitoring
  15. Log Management
  16. Domain Reports
  17. Node Diagnostics
  18. Understanding Globalization
  19. Managing Distribution Packages
  20. Appendix A: Code Pages
  21. Appendix B: Custom Roles
  22. Appendix C: Informatica Platform Connectivity
  23. Appendix D: Configure the Web Browser

Administrator Guide

Administrator Guide

Native Connectivity

Native Connectivity

To establish native connectivity between an application service and a database, you must install the database client software on the machine where the service runs.
The following table describes the syntax for the native connection string for each supported database system:
Database
Connect String Syntax
Example
IBM DB2
dbname
mydatabase
Microsoft SQL Server
servername
@
dbname
sqlserver@mydatabase
Oracle
dbname.
world (same as TNSNAMES entry)
oracle.world
Sybase ASE
servername
@
dbname
sambrown@mydatabase
Sybase ASE servername is the name of the Adaptive Server from the interfaces file.
Teradata
ODBC_data_source_name
or
ODBC_data_source_name@db_name
or
ODBC_data_source_name@db_user_name
TeradataODBC
TeradataODBC@mydatabase
TeradataODBC@sambrown
Use Teradata ODBC drivers to connect to source and target databases.

0 COMMENTS

We’d like to hear from you!