3. Open Omniscope, drag in a "Database table" block from the sources.
4. In "Select database" choose "JDBC (Advanced)".
5. In "Driver jar path" select the JDBC driver downloaded in step 2.
6. In "Driver class:" enter "jdbc".
7. In "JDBC URL" enter "jdbc:q:localhost:5000". If we are running KDB on a different port change the url.
8. Enter the username/password (if configured).
9 Click the "Connect" button. You should now be able to select a table and download the data, incorporating it into your DataManager workflow.
I've attached a screenshot with a configuration I was successfully able to use to connect and download 1 million records into Omniscope. This runs in a few seconds with the sample data I tested.
In the next few days we intend to add "KDB" to the list of supported databases, so you can use this instead of having to select the "JDBC (Advanced)" option. I'll post back once this has been implemented.
In the meantime please let us know if you encounter any problems using the method described above.