Answered

How do you integrate to an external database that doesn't follow Bizagi's restrictions

Is there a way to connect to a database using virtualization, that doesn't follow bizagi's rules on unique IDs/primary key?

We have different data sources we connect to, many of them legacy and outside our dept. - which aren't always well defined. I tried connecting to some test ones using virtualization and got errors complaining about unique ID missing. I don't want to have to setup a replication for these because then we end up with loads of duplicate data everywhere.

Is there a workaround? I'm new to bizagi, so I might be just missing something

Best Answer
photo

Dear Prakash,

Bizagi provides a Replication Wizard to assist in connecting to an external sources such as SQL Server and Oracle (for data-level integration). For any data source other then SQL Server and Oracle, there is the possibility to override the methods and classes used by Bizagi in its Replication feature.For further information: http://help.bizagi.com/bpmsuite/en/index.html?custom_replication_and_virtual.htmAlso, This Web method is used to update information in an Entity in Bizagi's data model (from an external application).Updating information in an Entity involves: inserting new records, modifying existing ones, or disabling (logical deletion) existing records. This method is specially used for Parameter Entities in Bizagi; given that such records (lists of values) are never modified from a Process instance.This method receives a single input having the values to insert, modify or disable, for the attributes and relations in a start-point Entity.For further information: http://help.bizagi.com/bpmsuite/en/index.html?saveentityasstring.htmRegards

photo
0

Dear Prakash,

Bizagi provides a Replication Wizard to assist in connecting to an external sources such as SQL Server and Oracle (for data-level integration). For any data source other then SQL Server and Oracle, there is the possibility to override the methods and classes used by Bizagi in its Replication feature.For further information: http://help.bizagi.com/bpmsuite/en/index.html?custom_replication_and_virtual.htmAlso, This Web method is used to update information in an Entity in Bizagi's data model (from an external application).Updating information in an Entity involves: inserting new records, modifying existing ones, or disabling (logical deletion) existing records. This method is specially used for Parameter Entities in Bizagi; given that such records (lists of values) are never modified from a Process instance.This method receives a single input having the values to insert, modify or disable, for the attributes and relations in a start-point Entity.For further information: http://help.bizagi.com/bpmsuite/en/index.html?saveentityasstring.htmRegards

photo
0

Hi Juan

If i understand correctly, that means that if I have a read only SQL/Oracle source that I need to read data from, but doesn't follow strict unique/primary key constraints, the only way I can read from it is to setup replication ?

Thanks

Have a nice day

photo
0

Dear Prakash,

Bizagi allows you to virtualizate and/or replicate entities from SQL Server and Oracle by default. If you need to implement another external database or another system, then, you need to create a library to connect and to work correctly.

For further information:

Regards

photo
0

Hi Juan

I've gone through those articles. I'm trying to get a very specific answer to my question - not a generic article on how to use replication/virtualization.

My question is - since virtualization seems to require the tables to be in a specific unique key/primary key constraint, is replication the only workaround if the tables I'm trying to read do not have a unique/primary key. The tables I'm trying to read are in SQL server.

Thanks

photo
0

Dear Prakash,

You are correct. All the entities require to have PK (Primary Key) in order to import correctly and not to duplicate items during the process.

Regards