In Informatica Cloud Application Integration (CAI), interacting with a database using a JDBC connection involves connecting to the database to perform various operations such as querying, inserting, updating, or deleting records.
JDBC Connector extends generic connectivity to databases that Informatica does not have access to through the Informatica Application Integration native connectors. When you use JDBC Connector, Informatica does not guarantee that the functionality or performance might be equivalent to what you expect when you use the Informatica Application Integration native connectors.
- Knowledge of Cloud Application Integration processes.
- Knowledge of JDBC Connector.
- Understanding of databases, and how to create connections and processes in Application Integration.
- Use the JDBC type 4 driver.
- The database supports JDBC Specification 3.0 Java API and Type 4 Database Protocol Driver.
- To connect to databases such as IBM DB2, Microsoft SQL Server, MySQL, Oracle, and PostgreSQL by using a JDBC type 4 driver.
- User should be able to connect to multiple DBs in CAI.
- Perform various operations such as querying, inserting, updating, or deleting records in the DB.
- Administrator/Architect
- Developer
Ask An Expert
Feature Clarity
Cloud Application Integration
Ask An Expert
Implement
Adoption - Technical
Functional
AAE-CAI-016
Disclaimer
- All the topics covered in the Success Accelerators/Ask An Expert sessions are intended for guidance and advisory only. This is implicit and it will not be called out under the scope of each engagement.
- Customers need to include their relevant technical/business team members highlighted in each engagement topic to derive the best out of each engagement.
- Customers need to perform any hands-on work by themselves leveraging the guidance from these engagements.
- Customers need to work with Informatica Global Customer Support for any product bugs/issues and troubleshooting.