I am working on deploying Creatio on-site in order to check heavy sql queries to add some indexes. I have been following the steps on the documentation page for on site installation, however I am having trouble finding the ConnectionsStrings.Config file and any help figuring out where I should look would be greatly appreciated.
I am confused on file path to get there. I received a database backup from support and then deployed the backup by restoring the database in MS SQL Server Manager. Is there someplace else I should be looking?
To create an on-site install, you need the database, which it sounds like you already have, but you also need the actual application files that you setup under IIS. You can get this from support (it needs to match the version of the database backup you've been given)
Hi.
Our intention is create a console app (C#) using EntitySchemaQuery that query an entity (like Account or Contact) and gets its rows to populate a local table.
We are trying to connect our bpmonline using this example:
source: https://www.bpmonline.cz/bpmonlinesdken/UsingEntitySchemaQuery.html
//////////
// Creating a query instance, adding columns and a data source in the query.
Select selectQuery = new Select(UserConnection)
.Column("Id")
.Column("Name")
.From("Contact");
// Executing a database query and getting the resulting dataset.
using (DBExecutor dbExecutor = UserConnection.EnsureDBConnection())
{
using (IDataReader reader = selectQuery.ExecuteReader(dbExecutor))
{
while (reader.Read())
{
// Handling the query results.
}
}
}
/////////////
The problem is we do not know how to create the connection string (UserConnection) to our cloud services, https://mycompany.bpmonline.com.
How to create this UserConnection? Someone has an example or may guide us?
Theoretically, it's possible to use bpm'online local .dll-s and create the connection. However, it's very hard and usually pointless. If you need to get data from bpm'online, please create a web service in bpm'online. The service should get the needed data and give it to the requested.
I'm trying to achieve the same goal to increase our developers' productivity.
We usually use task script in the process designer to manipulate data using EntitySchemaQuery.
Each time, we have to update the process, run it and check the log or attach visual studio debugger (which is painful) to verify our code.
Imagine if we are able to get a UserConnection instance directly into a standalone app. we can test our functions faster and increase the overall productivity.
