I have a business requirement to integrate one creatio system to another. Can anyone help me with the steps required to implement this, if such an integration is possible at all?
I have a business requirement to integrate one Creatio system to another Creatio system. Can anyone help me with the steps required to implement this, if such an integration is possible at all?
We have a use case where Creatio co-exists with a legacy application which is SQL heavy - A lot of logic is written using SQL Stored procedures. There are certain custom objects on Creatio that needs to be populated and read by the legacy app on a weekly basis. Integration via APIs is not an option (owing to all the business logic being already available in Stored procedures). Using Excel Import/Export is also not an option.
We are considering an ongoing ETL via SQL where a stored procedure is used to directly write/read info from Creatio's custom tables. Assume that the Legacy application has a good understanding of the schema and relationships and transformation/mapping to/from Creatio tables is not an issue.
Pls comment on the following -
1. Is this feasible? - In my view, this should definitely be feasible as at the end of the day, It is an SQL DB. Any data read out of Creatio's DB does not disturb the state of the data in the DB. Any data modified (correctly) in the DB should reflect correctly in the Creatio application. Can you confirm?
2. Is this recommended? - Apart from ease of use and need for SQL development, Are there any reasons from a Creatio product/architecture stand point why this might not be recommended? The load on the WebServer is a negligible factor as these SQL import/export will only be done during low usage periods weekly.
Can you please check this Marketplace add-on, I believe it can help you with your business task.
But still, if you decide to use your approach, then:
1. Yes, that is feasible. The data will be available in the Application but you need to understand that if you miss to insert something, the data might be corrupted. Also, this kind if data transfer won't trigger BP as this will be considered to be direct data insert into the DB.
2. I can not say that this approach is recommended but it is possible. And again, you need to perform a lot of testing before real data transfer just not to lose data.
Can you please check this Marketplace add-on, I believe it can help you with your business task.
But still, if you decide to use your approach, then:
1. Yes, that is feasible. The data will be available in the Application but you need to understand that if you miss to insert something, the data might be corrupted. Also, this kind if data transfer won't trigger BP as this will be considered to be direct data insert into the DB.
2. I can not say that this approach is recommended but it is possible. And again, you need to perform a lot of testing before real data transfer just not to lose data.
Yes, We did consider the plugin. But our use case needs to migrate data from a few custom SQL databases and on an ongoing ETL for 2 weeks. Also, We mostly have custom objects on Creatio and it is not a typical Creatio CRM that we are building.
#1 Yes, I understand that this won't trigger BPs. We are only doing this as a 1 time migration activity as our client is migrating an existing custom application to Creatio.
We have workflows & business logic configured at the Application layer (Via business processes, entity event listeners & incoming API integrations). However, we need to transfer some data into our Database only via direct SQL. Is there any way at all of triggering application level logic on some Database level triggers?
I can think of a few round about/hacky ways of achieving this. Want some input wrt support for DB to Application layer execution flow from a Creatio product stand point and any clean ways of doing this.
We have workflows & business logic configured at the Application layer (Via business processes, entity event listeners & incoming API integrations). However, we need to transfer some data into our Database only via direct SQL. Is there any way at all of triggering application level logic on some Database level triggers?
I can think of a few round about/hacky ways of achieving this. Want some input wrt support for DB to Application layer execution flow from a Creatio product stand point and any clean ways of doing this.
In case you need to interact with the database directly you need to use either stored procedures or triggers that could trigger additional actions upon some actions on the application level. This will be the easiest way to achieve your target.
I was referring to use cases like the following - When a SQL Trigger gets activated, Run a business process at the Application layer. There is no direct way to do this I would presume?
Also, the dbExecutor class will help perform operations unidirectionally from the Application layer to the DB layer. I don't think something like this is available - When a trigger runs at the DB layer, it is available as an Event to catch or subscribe to at the Application layer. Is this right?
A very distant example would be something like this -
You can call stored procedure using dbExecutor, but not visa versa (trigger calls a process). You can use another approach: insert data to the database and then call the process manually for all the records by their CreatedOn date value. As a result data will be inserted to the system and processed by a business process.
Thank you Oscar for your response. Yes, the final approach you have suggested is one of the ways I also thought about. It is still round about and non optimal. Appreciate your answer nevertheless.
We are using Creatio 7.16.3 Service enterprise on-premises (Infra on AWS cloud). We have a use case where certain fields on the Creatio GUI need to send and receive real time updates for a specific user across multiple browser client instances that s/he might be using.
We have zero-ed in on Firebase real time database to maintain state on the server side. We plan to establish Creatio client - Firebase interaction via the Firebase JS SDK to send and receive real time updates. Few clarifications below -
1. Have there been known instances of Creatio successfully integrating with Firebase real time database in the past? If Yes, any available material/documentation around the same would help.
2. Are there any gotchas or limitations we need to keep in mind from an implementation, security and performance perspectives specific to the Creatio product while integrating with Firebase real time database? Eg with Service workers.
4. Is there a way to directly inject a CDN link globally on Creatio without having to physically include the contents of the file as suggested in the above link?
1. We have checked the existing case history but unfortunately didn't find any request related to integration with Firebase service, sorry.
2. Unfortunately, we don't have any specific best practices for integrations. It is necessary to use generally accepted engineering practices and instructions but we will happy to assist with any difficulties you may have.
3. This question was already answered in the mentioned community post. Duplicating the answer here:
"Please call jQuery.getScript function in the console and review the sources tab as I recommended and use it as an example to add your own jQuery to the system"
4. As of now, there is no way to use CDN link in the Creatio application. If it will be available in future releases, you will be able to find this information in the Creatio release notes.
Please let us know if you have any other questions.
I have a legacy system built using EJBs in java on a JBoss app server. I need to integrate it with Creatio. What's the best way of integrating EJBs with Creatio? Are there any specific gotchas that I have to keep in mind around, JRE, cloud vs on-prem, etc?
TCP port 274 - required for connecting workstations to the server
TCP port 275 - required to connect the Server Management utility to the Infinity Guardian service
TCP ports 20, 21 - necessary for the operation of the integrated FTP server
TCP port 277 - used to send faxes
TCP port 3050 is used to connect to the Firebird database.
Infinity also requires ports that are used by IP nodes. This includes the main port, which uses the IP node and the range of ports that are used dynamically during the process of establishing VoIP connections and for transmitting voice messages.
Basic ports for SIP telephony are 5060 and 5061.
Infinity X Ports:
All ports can be configured in the settings. Below are the default ports:
10000 - to connect the server to the DBMS
10010 - to connect the client to the server
10019, 10020 - for connecting to Infinity 4
10040 - for connecting a browser to Infinity Guardian, as well as for automatically updating clients
10101, 10102 - for client access to the media storage
10103 port for playing recorded calls
The VoIP telephony can be configured in the settings.
My marketing team uses campaign monitor for sending bulk emails. Is there a way to integrate creatio and campaign monitor so that they can sync the data lists
This is theoretically possible and the scenario should be as follows:
1) Replace "BulkEmail" object in configurations and add new needed columns to this object (or simply use section wizard and create new columns there)
2) Create 3rd party integration via OData4 (this Creatio Academy article will be useful) on Campaign Monitor side.
The idea here is that each time you trigger this integration on Campaign Monitor side - data from Campaign Monitor is pulled out and bulk email record on Creatio side is being updated (using PATCH HTTP verb). New columns from step 1 will be used to store data that is being received from Campaign Monitor via OData4.
So the main part of this integration should be performed directly on Campaign Monitor side. You need to create a logic that will put needed data from needed columns into the request body and then you need to use PATCH HTTP request as specified in the article provided so to update existing bulk email record.
