Results 1 to 3 of 3

Thread: Access ODBC in LavaStorm

  1. #1

    Default Access ODBC in LavaStorm

    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
    Last edited by jpstory; 01-24-2018 at 09:46 PM.

  2. #2

    Default

    Hi

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

  3. #3
    Lavastorm Employee gmullin's Avatar
    Join Date
    May 2014
    Location
    Chicago
    Posts
    134

    Default

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •