RapidMiner

RapidMiner

Loading data from sql server db

Contributor II

Loading data from sql server db

Hi,

 

This is Saurabh here, Im trying to automate my daily task of loading data suing sql query(complex query which has multiple temp tables and joins) from sql server db, into Rapid miner to export the results into user defined excel format,

 

 I have tried using Read databsse operartor, but since my query is lengthy and has multiple components within it, it does not run, I also tried a combination of execute sql and read data base but no luck.

 

I would really appreciate if  someone can help me with my issue

4 REPLIES
RMStaff

Re: Loading data from sql server db

The Read Database Operator can handle very complex queries. Thats no problem. So this is the operator to go for.

 

~Martin

--------------------------------------------------------------------------
Head of Data Science Services at RapidMiner
Contributor II

Re: Loading data from sql server db

Yes thanks, but the Read data base operator does nto work for me, also this is a dynamic query which pulls all the trades from T-1 day and compares various attributes like Sales for different feed sources,(attributes like account no etc.)

Contributor II

Re: Loading data from sql server db

Also this mornign, Im getting this error

 

 

Highlighted
RMStaff

Re: Loading data from sql server db

For making the queries dynamic, you should use "Macros".  Here is a primer on this:  http://community.rapidminer.com/t5/RapidMiner-Studio-Knowledge-Base/How-to-Use-Macros/ta-p/32966

 

Cheers,

Ingo


How to load processes in XML from the forum into RapidMiner: Read this!