iwofda
Last Updated: February 25, 2016
·
428
· jairyg
Sideprofile

Manage Tables in External DB through Allegro

Allegro 8.x has the ability to manage tables in a separate (non-Allegro) database. However, there are several steps to configure this in order for it to work properly.

First, you'll need to make sure that the Allegro data source user has permissions to the database. If you're linking to another server, you'll need to make sure that you have the linked server set up properly.

  1. Create the tables in the external database (if needed)
  2. Create the Data Views in Allegro using a query that refers to the full data table name ([server].[database].[owner].[table]). Note that you may only have one table in your query.
  3. Synchronize the database
  4. If you have multiple tables that are related, you'll need to create the necessary Data Constraints and assign them as well as the primary keys for the tables in the Data Columns views. Allegro will use this metadata when making sending DML to the external DB.
  5. Create a Visual Model View with all tables. You can use just about any class, however if you create a custom class and implement it using Class Events, you'll run into some issues. It's best to use a class that isn't implemented this way.
  6. In the newly created view, you can retrieve or update the data in the external database through the views created.
Say Thanks
Respond

1 Response
Add your response

11454
Sideprofile

Note that the syntax above is for MS SQL Server. You'll have to modify to PL/SQL for Oracle implementations.

over 1 year ago ·