how to register an external table for dynamic field from oracle database or sql server where hosted on different machine ?

SELECTED ANSWER

replied on April 28, 2014 • Show version history

The external table needs to be hosted on the same server as your Laserfiche repository database (if you are using Microsoft SQL Server) or in the same database (if you are using Oracle).

More information about External Tables and how to configure them can be found here.

0 0

View 2 previous replies

replied on April 28, 2014

thanks a lot.

what shall i do if my client requirements to have an external table from different server ? as long as data replication ( copy of external DB on same Laserfiche server) is not a preferable solution.

regards

0 0

replied on May 1, 2014

The external table has to be held on the same server as your Laserfiche repository database. You will need to make a copy of the table which could be automated by using Workflow. The main activities you will need are Query Data (retrieve data from the third party database) and Insert Data (append data into the database server hosting Laserfiche).

0 0

replied on July 12, 2014

Querying the third party database and inserting that data into a local database works fine however if entries are added or deleted from the original list how can I maintain the local database using Laserfiche workflow? Original list on server I cannot update or change.

Such as the example below.

Tom

Dick

Harry

I copy this list put in a local database. Ok now the original changes

Tom

Susie

Harry

If I run the same import again i get.

Tom

Dick

Harry

Tom

Susie

Harry

Is there a way to delete local data with LF Workflow?

0 0

replied on July 14, 2014 • Show version history

Hi Scott,

For this you will need to compile a custom Query. However if you are going down this road you may as well set the replication up within SQL.

You can use SQL agent to create a package to replicate the data from one table in one SQL instance to another server and/or instance.

There is plenty of information available online about this. You may need a little bit of SQL query knowledge to complete this. (consult Google)

This seems a pretty good guide to get you started http://www.databasejournal.com/features/mssql/article.php/1438201/Setting-Up-Transactional-Replication-A-Step-by-step-Guide.htm

Hope this helps!

2 0

replied on May 20, 2015

Hi Cathy,

A small update here.. The view or table has to be in the same schema, not database, for Oracle systems.

-Ben

0 0

Question

Question

how to register an external table for dynamic field from oracle database or sql server where hosted on different machine ?

Answer

Replies

Sign in to reply to this post.