Automate DataLink Process

3.27K viewsGeneral Discussion
0

Hello Guys

First of all thank you very much for all the favors. With your help I am able to make a simple plugin application “Hello World”.

Now I want to shift my track that leads to my goal. Actually I want to use Quantrix in my application. I want to populate quantrix from my database application.

My first step is to Automate Data Link process. From my database application I will select the SQL Server Data base table and I want to see this table in Quantrix as we do in DataLink.
It means my database application will populate the quantrix.

Can I have any good suggestions before start.
Can I call some pre-written functions that quantrix calls in DataLink Process.
Can some one guid me?

Thanks
Abrar

0

Greetings GreatAbrar,

Based on your posting I’m not sure I fully understand what you are trying to accomplish. However, here are two possible approaches to importing data into a Quantrix model through the QAPI. Assuming you have an IAction that connects to your database and performs a query using JDBC:

1) You can create a table in the model using the Model.createMatrix() and manually build the matrix to receive the data. Then you could iterate over the cells in the matrix and pull the data from the ResultSet into the matrix using a CellCursor.

2) You can implement the IDataGrid interface wrapping your ResultSet and pass that to the Model.importData() method which takes an IDataGrid and a Map defining all of the parameters necessary to do either a two dimensional import or an OLAP import.

#2 is essentially like executing the DataLink wizard but through the QAPI. Configuration of the Map is a bit tricky and will take a careful reading of the ImportMapKeys and some experimentation to figure out the right configuration for your needs.

Does that answer your question?

Cheers,

pete
peter m. murray

You are viewing 1 out of 5 answers, click here to view all answers.