Hi All
I have requirement to modify / insert data in oracle table from Appian , Please guide me how I can do this ? Any help would be highly appreciated.
Regards
Shrirang
Discussion posts and replies are publicly visible
Assuming that your Oracle datasource is already configured, if you want to insert/update data into a table, please follow the below steps. 1. Create a CDT. 2. Create a datastore and map the respective datasource. 3. Add the cdt as data store entity in the datasource. Create a constant for the data store enitiy. 4. Use write to data store entity to insert data into the table. If you want to update a particular row , then make sure the id(primary key) field in the cdt already exists. Please look into the below documentations. docs.appian.com/.../Custom_Data_Types.html docs.appian.com/.../Data_Stores.html docs.appian.com/.../Write_to_Data_Store_Entity_Smart_Service.html Hope this helps, if not please elaborate the requirement..