RulePoint
- RulePoint 6.2
- All Products
Property
| Description
|
---|---|
Name
| Name of the source. The source name must be unique.
|
Description
| Optional. The description of the service. Make the description intuitive so that other users can relate to the use of this service.
|
Type
| Type of source. Select
SQL Source .
|
Connection
| Select the connection name to which you want to associate the source. You must create a JDBC connection before you create an SQL source.
|
Topic
| The topic to which the RulePoint posts the events. Select the topic name that corresponds to the source.
|
SQL
| The SQL query to run against the target database.
Use double angle brackets (chevrons) surrounded column names (<<column name>>) to identify the substitution parameters in the SQL statement.
Each column name becomes a topic property. The topic property name is the SQL column name and the topic property value is the SQL column value.
|
Update SQL
| Optional. You can run the UPDATE statement for each record extracted from the query and published to RulePoint. You can parameterize the SQL statement with SQL query column names.
|
Transaction Size
| The frequency to update the parameters with data from the most recently processed records. The frequency is measured in numbers.
When you input a SQL UPDATE statement, the transaction size is the number of UPDATE statement invocations allotted for each transaction based on the number of records published.
An SQL source calls an update query as per the specified transaction size. You can set the following transaction sizes:
|
Buffer Result
| It determines whether to maintain a buffer of the result sets to publish to the topic. Used only when defining a SQL source service.
Select from the following options:
|
Marker ID
| Optional. The name to assign to the marker. This is the batch name that the sever associates with all published events. Avoid using multiple batch names as the system treats them as a single string. Specify one batch name for each source.
When you configure a marker ID in the source, it demarcates a set of events between the marker_begin and the marker_end event. For more information, see "Markers" in the
RulePoint Administration Guide .
|
Parameters
| Optional. The parameters to use in the SQL query. Enter the parameters separated by comma.
Parameters are a set of name value pairs to substitute as values to the parameters in the SQL query. The field has values if the SQL query has parameters. Parameters sent to the SQL query are empty strings for empty fields.
|
Property Metadata Map
| Optional. The unique name-value pairs of static metadata or additional information about this service that becomes part of the event properties.
Do not use a null value for any property. Do not include space in the name of the metadata property. The name-value pairs appear in every event published by this source service.
Format for Property Metadata:
Name=Jane Doe, Age=10 If you input an entry that contains a delimiter, such as a comma or a semicolon, you must place the entry into a quote. Putting a numeric entry into quotes makes it a string or non numeric. You cannot do math computation with a non numeric entry.
|
Marshaller Class Name
| Class name of the marshaller. The marshaller class is responsible for converting or enriching the source event properties. It must include the full class name including the classpath. You must add the jar containing this class into the RulePoint library.
|
Marshaller Properties
| Properties of the marshaller. You must pass the properties as key value pairs, separated by a comma, to the marshaller class. For example, property1=value1,property2=value2.
|