A CustomSQL service defines and executes custom SQL to perform database operations. You can execute almost any SQL statement required by integrations, such as data management statements. You configure Adapter for JDBC services using Designer. For more information about adapter services, see Using Adapter Services.

If you need to write custom SQL, you can create a service that uses customized SQL statements. This allows you the flexibility to execute almost any SQL statements required, such as data management statements and data definition statements, including insert, select, update, and delete.

Because an adapter service that uses custom SQL provides no error checking, be sure that your SQL statement works correctly. You can verify SQL statement accuracy using your vendor's SQL utility. For details, see your vendor documentation.

Be sure to review the section Before Configuring or Managing Adapter Services before you configure adapter services.