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

Connection Management

Connection Management

After you create a connection, you can view the connection, configure connection properties, and delete the connection.
After you create a connection, you can perform the following actions on the connection:
Configure connection pooling.
Configure connection pooling to optimize processing for the Data Integration Service. Connection pooling is a framework to cache connections.
View connection properties.
View the connection properties through the
Connections
view on the
Manage
tab.
Edit the connection.
You can change the connection name and the description. You can also edit connection details such as the user name, password, and connection strings. When you update a database connection that has connection pooling disabled, all updates take effect immediately.
The Data Integration Service identifies connections by the connection ID instead of the connection name. When you rename a connection, the Developer tool and the Analyst tool update the jobs that use the connection.
Deployed applications and parameter files identify a connection by name, not by connection ID. Therefore, when you rename a connection, you must redeploy all applications that use the connection. You must also update all parameter files that use the connection parameter.
Delete the connection.
When you delete a connection, objects that use the connection are no longer valid. If you accidentally delete a connection, you can re-create it by creating another connection with the same connection ID as the deleted connection.
Refresh the connections list.
You can refresh the connections list to see the latest list of connections for the domain. Refresh the connections list after a user adds, deletes, or renames a connection in the Developer tool or the Analyst tool.

0 COMMENTS

We’d like to hear from you!