Adding Message Component Instances or SQL Sessions
For queues, iterators, aggregators, invokers, or transformers, you must associate the step with a message component instance. An instance allows you use a message component in a process step. For information about the component types, see Process Steps and Associated Components.
For SQL step, you must associate it with an SQL session.
You must create these component instances and SQL sessions and then associate them to the steps.
Adding Message Component Instances
You can add a message component instance in two ways:
• Add the message component instance from the Step Properties tab.
• Add the message component instance on the Configuration tab > Message Component section and associate the component instance on the Step Properties tab.
Adding Message Component Instance on Step Properties tab
To add a message component instance on the Step Properties tab:
1. After you add the required step on the canvas, double-click the step to open Step Properties.
2. From the Select <component> drop-down list, select Add a New <component>. The <component> is based on the step type. From example, if you have double-clicked on an Invoker step, then <component> displays the name as Invoker.
The Add <component> Component window is displayed.
3. Specify the Component Name, select the required component Type, set the Properties, and click Save. For information about the types and its properties, see Process Steps and Associated Components.
The new component instance is added to the Select <component> drop-down list. The same component instance also appears on the Configuration tab > Message Components section.
Adding Message Component Instance on Configuration tab
To add a message component instance on the Configuration tab:
1. Go to the Configuration tab > Message Component section.
2. Click the 
icon to add a component instance.
icon to add a component instance.The Add Message Component window is displayed.
3. Specify the Component Name, select the component Category and the required component Type, set the Properties, and click Save. For information about the types and its properties, see Process Steps and Associated Components.
The new component instance is added to Configuration tab > Message Components section. The same component instance also appears in the Step Properties tab > Select <component> drop-down list when you double-click the respective component on the canvas.
Manually Deploying Message Components
To manually deploy a message component:
1. Obtain the .zip file related to the message component that you want to deploy and copy it to the following location:
C:\ProgramData\Actian\DataConnect\dc-rcp-64-bit-11.X.X-X\Plug-Ins
2. Restart DataConnect.
Adding SQL Sessions
Use SQL sessions options to set up pipelines to applications, middleware, or SQL databases. Sessions are an efficient way of opening connections, and leaving them open while performing different operations.
For example, you can issue a drop table statement to one Oracle table, then run a transformation to create or update a different table, without opening and closing the connection to Oracle twice. The session keeps the connection live for both steps.
Sessions are reused. When a step opens a session, that session remains open throughout the process. This means that subsequent steps in the process can see changes to an object in the database. Transactions are associated with sessions, and this enables steps to collaborate within the process.
Note: You can view SQL session information for connection to ODBC data sources and relational database management systems (RDBMS).
To add SQL sessions, go to the Configuration tab > SQL Session section. For more information, see Configuring SQL Session section in Configuring Processes.
Last modified date: 08/02/2023