Question

How to Configure External Tables in Oracle

Administration Laserfiche

Updated May 21, 2015

asked on May 19, 2015

Hi guys and gals,

Could someone help me with information on how to configure external tables on Oracle and LF9.2.1? For one thing, it asks for a schema name but not password. I've tried to add a view but wasn't successful.

-Ben

0 0

Answer

SELECTED ANSWER

replied on May 20, 2015 • Show version history

Hi Ben,

EDIT: To register an external table on Oracle in the Laserfiche Administration Console the table must be on the same database as the repository. In addition, the same Oracle username and password will be used as the rest of the Laserfiche system. This is because Laserfiche uses a single Oracle username and password to authenticate. For this reason, you are not asked to put in a password when registering an external table.

For step-by-step instructions on registering external tables in Laserfiche, take a look at this section of the help files.

I hope this helps! If you have other questions that you can't find an answer to feel free to respond.

EDIT: Inconsistencies in documentation will be corrected soon.

0 0

Replies

replied on May 20, 2015

Actually, you can use other Oracle schemas, they do not need to be the same. There's some potentially complicated security involved to ensure that your main Oracle schema is able to access the other one and that's caused some confusion in the past, but it's supported and no software change request is needed.

1 0

replied on May 20, 2015

Hi Kelsey,

Thanks for your reply and pointer to the online documentation. That means mixing my custom tables and views with Laserfiche tables and views. I' like to submit a change request to allow a different schema.

Also, this thread needs to be updated because it says "in the same database (if you are using Oracle)."

https://answers.laserfiche.com/questions/55079/how-to-register-an-external-table-for-dynamic-field-from-oracle-database-or-sql-server-where-hosted-on-different-machine--

-Ben

0 0

replied on May 20, 2015

Thanks for pointing it out! I have now edited my response!

1 0

replied on May 20, 2015

Interessant...

Could you guide me on how to explain the security requirements to an Oracle DBA please? I'd like to move the views to a different schema and i won't have access to make the changes myself.

-Ben

0 0

replied on May 20, 2015

You would want to grant the LFS schema user privileges to select from the other schema's table. You would also want to create a synonym for the table to make your life easier by not having to always prefix table names with their schemas.

1 0

replied on May 21, 2015 • Show version history

Thanks Miruna and Justin. I'll take that to the DBA.

0 0

You are not allowed to follow up in this post.

Question

Question

How to Configure External Tables in Oracle

Answer

Replies

Sign in to reply to this post.