The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

Loading data from sql server db

saurabh_jhaverisaurabh_jhaveri Member Posts: 4 Contributor I
edited November 2018 in Help

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

Tagged:

Answers

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 RM Data Scientist

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

     

    ~Martin

    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • saurabh_jhaverisaurabh_jhaveri Member Posts: 4 Contributor I

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

  • saurabh_jhaverisaurabh_jhaveri Member Posts: 4 Contributor I

    Also this mornign, Im getting this error

     

    image

     

  • IngoRMIngoRM Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University Professor Posts: 1,751 RM Founder

    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

Sign In or Register to comment.