Interface kdb to other databases

[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.

[Ryan Hamilton]

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 ..


[Author]

Posts