Question

Adding Windows ODBC connection for external tables.

Laserfiche Version 9 Version 8 Administration

Updated December 3, 2013

asked on May 15, 2013 • Show version history

Hello-

Is there a way to add excel or access database connection for external tables?

I am trying to add external table for dynamic field.

Is it possible to add excel or access ODBC connection?

Thank you!

0 0

Answer

APPROVED ANSWER

replied on May 22, 2013

External tables only supports SQL and Oracle databases. Check out this portion of the help files:Registering an External Table.

Regards

0 0

Replies

replied on December 3, 2013

Hi Anonymous,

(I posted this reply to another question but it might be useful for you, too)

I encountered a similar scenario for a customer who wanted to use data stored in MySQL for use with Laserfiche. SQL Server can be used to link to remote servers, including ODBC, MySQL (via ODBC) and Oracle and this gave us the ability to query MySQL from within Laserfiche. You'll have to create a view in MSSQL for the linked server.

In that particular solution, the customer required live data from their sales database. If the data doesn't need to be live, you could set up a scheduled task to periodically copy the Oracle data to an MSSQL database.

Server Objects - Linked Server

2 0

You are not allowed to follow up in this post.

Question

Question

Adding Windows ODBC connection for external tables.

Answer

Replies

Sign in to reply to this post.