Create Table in a Database

Automation Studio
1

I want to create a table in a database and insert queries into it as a part of weekly reporting.

Can this be done using AssistEdge?

2

Database Applications - for Automation of CRUD scenarios in Database.

Refer Link for More details -

https://www.edgeverve.com/assistedge/knowledge-base/RPA19.1/Automation_Studio/Configuring-Automation-Processes/Process_Components/Applications/Database_Applications/Database_Applications.htm?rhhlterm=database&rhsearch=Database

3

Hi @Mantri

To automation database

  1. Create Database Application where you need to pass database details to connect with database
  2. Use Execute Database Query activity to execute your query/stored procedure
4

Hi @sumit.sagar and @bhuvan

I am getting the below error while passing the query - Query cannot contain keywords create, update, delete, alter drop

image

5

Hi @Mantri

Create a stored procedure to perform DML and DDL operation.