Adapter for Apache Kafka 9.6 | webMethods Adapter for Apache Kafka Documentation | webMethods Adapter for Apache Kafka Installation and User’s Documentation | Adapter for Apache Kafka Connections | Configuring an Adapter for Confluent KSQL Connection
 
Configuring an Adapter for Confluent KSQL Connection
When you configure Adapter for Apache Kafka , you specify information that Integration Server uses to connect to an Confluent Kafka system. You can configure Adapter for Apache Kafka connections manually using the Integration Server Administrator screen.
*To Configure KSQL Connection
1. In the Adapters menu of Integration Server Administrator's navigation area, click webMethods Adapter for Apache Kafka.
2. On the Connections screen, click Configure New Connection.
3. On the Connection Types screen, click Confluent for Kafka KSQL Connection to display the Configure Connection Type screen.
4. In the webMethods Adapter for Apache Kafka section, use the following fields:
Field
Description
Package
The package in which to create the connection.
You must create the package using Designer before you can specify the package using this parameter. For general information about creating packages, see webMethods Service Development Help.
Note:
Configure the connection in a user-defined package rather than in the adapter's package. For other important considerations when creating packages for Adapter for Apache Kafka see, Overview of Package Management
Folder Name
Specifies the folder in which you create the connection.
Connection Name
Specifies the name you want to give to the connection.
Connection names cannot have spaces or use special characters reserved by Integration Server and Designer.
For more information about the use of special characters in package, folder, and element names, see webMethods Service Development Help.
5. In the Connection Properties section, use the following fields:
Field
Description
KSQL Server URL
Defines the KSQL server REST endpoint URL.
User Name
Defines the username if the KSQL server is configured to use Basic authentication.
Password
Defines the password If the KSQL server is configured to use Basic authentication.
Connection Timeout
Defines the time(in milliseconds) to establish the connection with Server.
Read Timeout
Defines the time(in milliseconds) waiting for reading the data - after establishing the connection; maximum time of inactivity between two data packets
Keystore Alias
Specify the alias name created for keystore using IS/security/keystore/Create Keystore Alias.
Truststore Alias
Specify the alias name created for truststore using IS/security/keystore/Create Truststore Alias.
Verify Hostname
Specifies whether to verify hostname. If true then org.apache.http.conn.ssl.DefaultHostnameVerifier is used.
For more information on about configuring keystore and truststore aliases and securing communication with Integration Server, see the webMethods Integration Server Administrator’s Guide
6. In the Connection Management Properties section, use the following fields:
Field
Description
Enabling Connection Pooling
Enables the connection to use connection pooling.
For more information see, Adapter Connections.
Note:
If you plan to enable connection pooling in a clustered environment, consider the connection pool size.
Minimum Pool Size
If the connection pooling is enabled, this field specifies the number of connections to create when the connection is enabled.
The adapter will keep open the number of connections you configure here regardless of whether these connections become idle.
Maximum Pool Size
If connection pooling is enabled, this field specifies the maximum number of connections that can exist at one time in the connection pool.
Pool Increment Size
If connection pooling is enabled, this field specifies the number of connections by which the pool will be incremented if connections are needed, up to the maximum pool size.
Block Timeout
If connection pooling is enabled, this field specifies the number of milliseconds that Integration Server will wait to obtain a connection with the KSQL Server before it times out and returns an error.
For example, you have a pool with Maximum Pool Size of 20. If you receive 30 simultaneous requests for a connection, 10 requests will be waiting for a connection from the pool. If you set the Block Timeout to 5000, the 10 requests will wait for a connection for 5 seconds before they time out and return an error. If the services using the connections require 10 seconds to complete and return connections to the pool, the pending requests will fail and return an error message stating that no connections are available. If you set the Block Timeout value too high, you may encounter problems during error conditions. If a request contains errors that delay the response, other requests will not be sent. This setting should be tuned in conjunction with the Maximum Pool Size to accommodate such bursts in processing.
Expire Timeout
If connection pooling is enabled, this field specifies the number of milliseconds that an inactive connection can remain in the pool before it is closed and removed from the pool.
The connection pool will remove inactive connections until the number of connections in the pool is equal to the Minimum Pool Size. The inactivity timer for a connection is reset when the connection is used by the adapter. If you set the Expire Timeout value too high, you may have a number of unused inactive connections in the pool. This consumes local memory and a connection on your backend resource. This could have an adverse effect if your resource has a limited number of connections. If you set the Expire Timeout value too low, performance could degrade because of the increased activity of creating and closing connections. This setting should be tuned in conjunction with the Minimum Pool Size to avoid excessive opening/closing of connections during normal processing.
Startup Retry Count
The number of times that the system should attempt to initialize the connection pool at startup if the initial attempt fails. The default value is 0.
Startup Backoff Timeout
The number of seconds that the system should wait between attempts to initialize the connection pool.
7. Click Save Connection.
Note:
The created connection will appear in the adapter's Connections screen and in Designer.