You can use Process Designer to interact with programs and services that are in Data Integration, inside your firewall, or anywhere in the cloud, as long as they have an API. For example, Google provides many APIs to access the services that Google provides.
You can create two types of service connectors:
Service Connector
You can create a service connector to connect to third-party services using REST or SOAP APIs.
Use one of the following ways to create a service connector:
- Manually create a service connector.
- Generate a service connector by importing a WSDL, Swagger JSON, or OpenAPI 3.0 JSON or YAML file.
- Download a service connector from GitHub.
- Download a service connector from Informatica Marketplace.
- Download a service connector from Administrator.
Data Access Service Connector
You can create a data access service connector on a Secure Agent to access data directly from a database.
You can use the data access service connector to connect to the following databases:
- Databricks
- IBM DB2
- Oracle
- Microsoft SQL Server
- MySQL
- PostgreSQL
You can create a data access service connector by defining the database properties and specifying variables to interact directly with the database. Using this service, you can create an invoke activity that executes SQL CRUD operations such as select, insert, update, or delete on a specified data source and receives responses based on the columns in the database table, expression, result set, and attachments from the data source.
To use the processes and services, perform the following steps:
1Create a service connector or data access service connector, an object that defines the interaction between Process Designer and the service, so that the connector can send and receive data.
2Define an app connection that a process can use to access the service.
3Add a Service step to the process where you want to use the service.
For example, the step shown in the following image uses the Get Vehicle Detail action to obtain information from Edmunds:
The services you enable using a service connector or data access service connector are accessible from processes.
The following image shows the process you go through to create a service connector:
