-
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.
-
Hi
Would appreciate if anyone can shed some light on the question, thanks!
-
Lavastorm Employee
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
-
Forum Rules