Hi Dear's,
I Need to connect me to a sql server on the cloud site. Is posible access to sql server by sql managment??
Regards,
Like
Dear Federico,
You can't get connected to the cloud site using SQL management due to security reasons. You can use SQL scripts quering a database in the advanced settings:
Regards,
Lily
Hello Federico!
Here is "tool" named SQLExecuterPage, see loaded file (compatible with bpm 7.9.1.x).
Installation:
1. Open [Configuration] section. Select your Custom package. Run [Import from file] action. Select this file. Press OK.
2. Edit "SQLExecuterPage" schema. Run [Publish] action. Wait for compilation to complete.
Usage:
1. Select "SQLExecuterPage", then right mouse click, then click on [Run] action. Additional window will appear.
2. Type any SQL query here, and then click on "Run SQL" button. You will get result for SELECT statement.
WARNING! Big risk of data loss or permanent database damage, please use this "tool" very carefully. This "tool" is not official and is offered "as is", only for developers purpose. But it works, and that is good.
WARNING! DML/DDL commands are executed silently, no any result messages.
Sorry, here is SQLExecuterPage791.md file:
https://drive.google.com/open?id=0B5hg2EOxCZsYR1NmWGhSX0NZbEk
Hi Dmitry,
Thanks for sharing the SQL file but while importing received warning message: "
The version of the imported item 7.9 differs from the 7.10 application version. This may cause errors in the workspace operation. Are you sure you want to proceed?"
Kindly let me know is it good to import it or is there any new version available?
Regards
Anupama
Dear Anupama,
You can install SQLExecuterPage791.md for 7.10 instance.
You can also find a free solution from our partner at the marketplace: https://marketplace.bpmonline.com/app/pt-sql-executor-bpmonline
Best regards,
Diana Adams