LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: jpstory

Hi All

I have a linked table in Access that pull data externally (from a server-based database), how do I replicate this process in LavaStorm?

I am totally new to this pulling-data-from-external-source thing, please be as detailed in your solution as possbiel, appreciate it !!!

Here's the connect string I found in Access (sensitive information masked, of course, hope this won't matter)

ODBC;dsn=Mydsn;database=MyDatabase;Server=sample.c ountry.abcd;port=10000;UID=userID;PWD=Mypwd;TABLE= dbo.ExtName

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: jpstory

Hi

Would appreciate if anyone can shed some light on the question, thanks!

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: gmullin

Do you want to pull the directly data from the source? Is the data lying in an SQL Server? If so, the easiest way is to use the JDBC Query node. To do so you would need to place the appropriate JDBC driver (you could try sqljdbc4.jar) in <LAE Install Directory>/lib/java/ext.

For SQL Server the node details would look something like this:
DbUrl: jdbc:sqlserver://<server>:<port>;databaseName=<database>;
DbDriver: com.microsoft.sqlserver.jdbc.SQLServerDriver

If its some other database (or you're querying Access directly), then its the same process but you need to find the appropriate JDBC driver.