data sharing with other software

Florian1

Forums

Hey,
I try to use Idea along with other software (Python and R) therefore i want a fast way to get the data out of Idea and into the other software.
I tried already a view things

  1. Writing data from Idea directly to an sql-Server via VBA but unfortunately VBA is so slow that it's no good solution.
  2. Conection via OLE to Idea-Server and iterating over the records out from python. Funny thing if you use the Spyde IDE you with send Idea Script code out from Python line by line, which makes scripting much more easier
  3. The fastest soltuion till now is write the data to xml from Idea and read it directly into python but i dont't like this solution because xml is no real database.

For me the nicest solution would be to read and write on the idea databank direktly. Has anyone from you an idea which databank Idea is using and if there drivers avialeable in any programming langugage?
 
Grettings from Austria
Florian
 

Brian Element Wed, 01/30/2013 - 17:48

Hi Florian, I posted the message on the IDEA forum and this was one of the admin's response.  Looks like it is with version 2 of what you are posting that they suggest.

Sortof, but you still need IDEA.

You can use OLE automation to read IDEA data files through IDEA methods. However the attached licenses must be maintained in order for the methods to work.

jvelasquez@lly… Fri, 03/22/2019 - 10:40

Hola, Estoy intentando usar la automatización de OLE para escribir un archivo word donde escriba los procesos que realizo en mi script. La intención es exportar el historial pero, al parecer, no se puede exportar el historial automaticamente.
 

Brian Element Fri, 03/22/2019 - 12:45

Hello Juan, 

Unfortunately there is not easy way to get the history out through IDEAScript.  The easiest way is to do it manually as there is an option to export it to a word, text or pdf document.

Brian