Interface kdb to other databases - Kdb+ / qStudio

Home Forums Kdb+ / qStudio Interface kdb to other databases

This topic contains 1 reply, has 2 voices, and was last updated by  Ryan Hamilton 6 years, 5 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #134

    Alan S

    Is there a way to interface kdb with other databases?
    I need to pull data from our other database on a regular schedule.

    #149

    Kdb has an odbc interface for pulling data in from other sources.
    http://code.kx.com/wiki/Cookbook/ODBC/qclient


    q)\l odbc.k
    q)h:.odbc.open `northwind / open northwind database
    q).odbc.tables h / list tables
    `Categories`Customers`Employees`Order Details`Orders`Products..
    q).odbc.eval[h;"select * from Orders"] / run a select statement
    OrderID CustomerID EmployeeID OrderDate RequiredDate..
    -----------------------------------------------------..
    10248 WILMK 5 1996.07.04 1996.08.01 ..
    10249 TRADH 6 1996.07.05 1996.08.16 ..
    10250 HANAR 4 1996.07.08 1996.08.05 ..

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.