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.  DB Store Node

    Employee
    Posted 02-21-2011 08:49

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

    Originally posted by: zon

    Hi,

    I've a quick question: I want to store in a table data about all CDRs, voice calls originated by our customers, so I can after make some queries and comparisions.
    I was trying to use node DB Store. But for this node I need Oracle installed on my PC? Is there other way of doing this without oracle?

    Best Regards,

    ZON


  • 2.  RE: DB Store Node

    Employee
    Posted 02-22-2011 01:32

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

    Originally posted by: mgajdosik

    Hi,

    you need to have at least Instant Client installed, which you can download from Oracle website. It is just interface that will connect to DB.

    Marek


  • 3.  RE: DB Store Node

    Employee
    Posted 02-22-2011 04:02

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

    Originally posted by: zon

    Hi Marek,

    Thanks again for your help.
    I checked and I do have the instant client installed in my PC.

    C:\oracle\ora92
    In this folder I have several folders. I really don't know how to deal with it or how to create the actual DB using this node. Can you help?

    Best Regards,

    ZON


  • 4.  RE: DB Store Node

    Employee
    Posted 02-22-2011 09:01

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

    Originally posted by: timonk

    Zon,

    You would not use a DB Store node to do table creation. DB Store is specific to loading information. If you also need to actually create tables through LAE, you want to use the DB Execute node, and utilize the appropriate SQL statements.

    I would recommend you look at your CORE library help for the DB Execute node, and review the "sqlNonSelect" BRAINScript command for executing those kinds of database operations.

    If the tables you want to access already exist, your oracle client software just needs to have the proper database TNS entries. You then simply tell the DB Store node which Oracle Database (DbService) you want, which user/password to get access, and which table (DbTable) you want to insert into. (the last DB Store parameter, "DbInterface", should be set to 'oci' for oracle databases).

    Regards
    -Timon