Hi All, I want to write a Smart Service which can interact witht the

Hi Sarat, here is our documentation on the subject:
forum.appian.com/.../Custom_Smart_Service_Plug-ins

May I ask what your use case is? Maybe we can identify a simpler approach.

If you are looking for a SQL based one, you may want to look into Query Database node that allows you to execute your SQL statements. This should cover the breadth of any SQL interactions you might require.

alex & sathya thank you both for the response.

Alex: I am aware of that documentation but my query was reg the package / classes / functions that can help me in writing custom smart service.
Sathya: I am looking some thing beyond Query Database, it will be helpful if you can give me classes or interfaces that i use to customize similar functionality.

Here is my scenario:
I want to write a smart service which takes “Data Store Entity” name (existing) , “DB Operation” i.e, (insert/update/delete) and “field” (upon which the operation to be performed in the table), condition (<, >, = value) as inputs and performs respective operation on the targetted table in the database.

I still wouldn't recommend creating a custom smart service for your requirement. You should be able to build a process in order to address your requirement. To the best of my knowledge (I may stay corrected), data store API's are not exposed as public API's. What you need to do is write your own logic to use JNDI context. This will serve you no better than using the Query database node.

If you're using an Oracle database you could use the Stored Procedure plugin to pass whatever you need to the database and perform the required action there.