Table of Contents

Search

  1. Preface
  2. Informatica Developer
  3. The Model Repository
  4. Searches in Informatica Developer
  5. Connections
  6. Physical Data Objects
  7. Flat File Data Objects
  8. Logical View of Data
  9. Viewing Data
  10. Application Deployment
  11. Application Patch Deployment
  12. Application Patch Deployment Example
  13. Continuous Integration and Continuous Delivery (CI/CD)
  14. Object Import and Export
  15. Appendix A: Data Type Reference
  16. Appendix B: Keyboard Shortcuts
  17. Appendix C: Connection Properties

Developer Tool Guide

Developer Tool Guide

Connections Overview

Connections Overview

A connection is a repository object that defines a connection in the domain configuration repository.
Create a connection to import data objects, preview data, profile data, and run mappings. The Developer tool uses the connection when you import a data object. The Data Integration Service uses a connection when you preview data, run mappings, or consume web services.
The Developer tool does not use connections to import flat file data objects or preview, read, or write flat file data.
The Developer tool stores connections in the domain configuration repository. Any connection that you create in the Developer tool is available in the Analyst tool and the Administrator tool.
Create and manage connections in the
Preferences
dialog box or the
Connection Explorer
view.
The Developer tool bar includes buttons for creating connections and showing connections. The Connection Explorer view also has a button for creating relational database connections.
  1. Connection Explorer view
  2. Create Connection
  3. Show Connections
After you create a connection, you can perform the following actions on the connection:
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.
The Data Integration Service identifies connections by the connection ID. Therefore, you can change the connection name. When you rename a connection, the Developer tool updates the objects 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.
Copy the connection.
Copy a connection to create a connection that is similar to another connection. For example, you might create two Oracle connections that differ only in user name and password.
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 Administrator tool or the Analyst tool.

0 COMMENTS

We’d like to hear from you!