LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  can LAE access to a DB2 database?

    Employee
    Posted 11-30-2015 09:02

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

    Originally posted by: Rafael

    Hello:

    Can LAE access to a DB2 database? Which node must be used, the ODBC generic node?

    Thanks.

    Rafa


  • 2.  RE: can LAE access to a DB2 database?

    Employee
    Posted 11-30-2015 09:03

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

    Originally posted by: CPereira

    Originally posted by: Rafael
					

    Hello:

    
Can LAE access to a DB2 database? Which node must be used, the ODBC generic node?

    
Thanks.

    
Rafa


    Yes, LAE can access DB2. Use the ODBC Admin on your machine to setup a connection then use the DB Query node to query the DB.


  • 3.  RE: can LAE access to a DB2 database?

    Employee
    Posted 02-24-2016 00:34

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

    Originally posted by: mallison

    Hi,

    I am just following up on this point. I went to ODBC Admin but did not have an option to set up the ODBC Driver for DB2 - is there any other way to query a DB2 database?

    Thanks!

    Marissa


  • 4.  RE: can LAE access to a DB2 database?

    Employee
    Posted 02-24-2016 01:39

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

    Originally posted by: Ivan

    If your ODBC data source admin doesnt show DB2 check if you have installed on your computer the drivers , you can search for those as "DB2 odbc drivers" for the DB2 version you have installed.

    you can also connect with JDBC, I pasted below an example (you can copy the text below and paste it on BRE
    the dburl and DbDriver may vary depending of your DB2 version) in this case you also need the DB2 JDBC drivers
    installed on your server if you connecting through LAE enterprise environment or on your desktop if you running the desktop at C:\Program Files (x86)\Lavastorm\LAE6.1\lib\java\ext

    JDBC node example to connect to a DB2 database.

    node:JDBC_Query_DB2
    bretype:core::JDBC Query
    editor:Label=JDBC Query DB2
    editor:sortkey=565dc11302d24c74
    output:@439f475045133ba6/=
    prop:DbDriver=com.ibm.db2.jcc.DB2Driver
    encrypted:simple=nFZhmIpYZmvjMtRGF8lNF91Rslivvj4=
    prop:DbUrl=jdbc:db2://192.168.1.104:50000/db2inst1:retrieveMessagesFromServerOnGetMessage=tr ue;
    prop:DbUser=db2inst1
    prop:SqlQuery=<<EOX
    select * from SYSIBM.SYSVIEWS
    EOX
    editor:XY=330,60
    end:JDBC_Query_DB2