CMDBuild Forum

Update Relations/Domains from WizardConnector

Old Versions
#1

Hi,

I have installed and configured correctly CMDBuild (last release, 2.3.3) on a CentOS 6 server.

The purpouse of this conversation is to verify some doubts related with the WizardConnector.

I have configured some processes (WizardConnectors) that update automatically my entities from another postgresql database.

But, the point where I am really interested, and I don't know how to proceed, is about updating also automatically the relations (domains) between entities.

To clarify, an example: on the external postgresql database, I have a table with clusters and another with instances. Also I have an another table that matches ID_Cluster with ID_Instance. So I am able to upload all the registers from Clusters and Instances to CMDBuild but I don't know how to proceed to stablish the relations between them.

I know that adding some reference attributes could be a possible solution. But that's none of my purpose.

Thanks in advance.

 

Max

#2

Using the Wizard Connector, you can synchronize relations only by using reference attributes (for 1:N relations).
Otherwise you have to use other solutions, such as the Advanced Connector (see CMDBuild Connectors Manuals http://www.cmdbuild.org/en/documentazione/manuali/connectors-manual).
CMDBuild Team

#3

Hi,

First of all, thanks for your quick response.

After going deep inside on this matter, I think it is unreliable to accomplish my client objectives (basically an automatic refresh for card relations from a Postgresql external database) by using the Wizard Connector or the Basic Connector (another client requisite is that the project has to be OpenSource).

In consequence, I want to ask if it is possible to have this automatic card relation refresh using any webservice (API). I have just started investigating on it and I have seen some methods as “createRelation” that maybe could help me.

Thanks in advance,

Max

#4

You can use the CMDBuild SOAP webservice or the CMDBuild REST webservice (see the CMDBuild_WebserviceManual).

Or you can use the CMDBuild Advanced Connector, available with the subscription.

CMDBuild Team

#5

Thanks for the response.

 

Ok, now that I have been testing the SOAP webservices, some doubts come to me.

For my case, I’m going to need to update a large quantity of relations (about 300K/day). So my doubt is if there is any methodology to follow, because with the way I’m testing, I have to apply for the webservice for each relation I want to update. And because my large number of relations, my methodology will probably waste an excessive amount of time and consumption of resources.

 

As always, thanks for the support.

 

Max

#6

I’ve accomplished what I think you are trying to do by scheduling SQL scripts to run directly on the database with cron.

Previously Martínez wrote:

Thanks for the response.

 

Ok, now that I have been testing the SOAP webservices, some doubts come to me.

For my case, I’m going to need to update a large quantity of relations (about 300K/day). So my doubt is if there is any methodology to follow, because with the way I’m testing, I have to apply for the webservice for each relation I want to update. And because my large number of relations, my methodology will probably waste an excessive amount of time and consumption of resources.

 

As always, thanks for the support.

 

Max