Options

MS SQL database connnection

ChicoChico Member Posts: 2 Newbie
edited February 2020 in Help
Hi there,

I'm not sure the database connection in rapidminer server is still available right now?

I was trying to create a new MS SQL connection in rapidminer server which is downloaded from aws marketplace. But the connection has failed.
After checking the iptable in the image, I couldn't find the 1433 port which MS SQL connection need it.

Any suggestions?

Kind regards,
Chico
Tagged:

Answers

  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,524 RM Data Scientist
    Hi,

    are you talking about our AWS images? As far as i remember we ship them with a postgres, not MS SQL.

    Best,
    Martin

    CC: @ZSzatmari


    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Options
    ChicoChico Member Posts: 2 Newbie
    Since I need to create a database connection to grab raw data in MS SQL server, but it looks like the port is not opened when I checked the iptables in the instance.

    ===
    AMI: RapidMiner Server 9.5.3 BYOL

    Chain INPUT (policy ACCEPT)
    target prot opt source destination

    Chain FORWARD (policy DROP)
    target prot opt source destination
    DOCKER-USER all -- anywhere anywhere
    DOCKER-ISOLATION-STAGE-1 all -- anywhere anywhere
    ACCEPT all -- anywhere anywhere ctstate RELATED,ESTABLISHED
    DOCKER all -- anywhere anywhere
    ACCEPT all -- anywhere anywhere
    ACCEPT all -- anywhere anywhere
    ACCEPT all -- anywhere anywhere ctstate RELATED,ESTABLISHED
    DOCKER all -- anywhere anywhere
    ACCEPT all -- anywhere anywhere
    ACCEPT all -- anywhere anywhere
    ACCEPT all -- anywhere anywhere ctstate RELATED,ESTABLISHED
    DOCKER all -- anywhere anywhere
    ACCEPT all -- anywhere anywhere
    ACCEPT all -- anywhere anywhere
    ACCEPT all -- anywhere anywhere ctstate RELATED,ESTABLISHED
    DOCKER all -- anywhere anywhere
    ACCEPT all -- anywhere anywhere
    ACCEPT all -- anywhere anywhere

    Chain OUTPUT (policy ACCEPT)
    target prot opt source destination

    Chain DOCKER (4 references)
    target prot opt source destination
    ACCEPT tcp -- anywhere xxxx.compute.internal tcp dpt:https
    ACCEPT tcp -- anywhere xxxx.compute.internal tcp dpt:http
    ACCEPT tcp -- anywhere xxxx.compute.internal tcp dpt:http
    ACCEPT tcp -- anywhere xxxx.compute.internal tcp dpt:webcache
    ACCEPT tcp -- anywhere xxxx.compute.internal tcp dpt:amqp
    ACCEPT tcp -- anywhere xxxx.compute.internal tcp dpt:amt-esd-prot
    ACCEPT tcp -- anywhere xxxx.compute.internal tcp dpt:pvuniwien

    Chain DOCKER-ISOLATION-STAGE-1 (1 references)
    target prot opt source destination
    DOCKER-ISOLATION-STAGE-2 all -- anywhere anywhere
    DOCKER-ISOLATION-STAGE-2 all -- anywhere anywhere
    DOCKER-ISOLATION-STAGE-2 all -- anywhere anywhere
    DOCKER-ISOLATION-STAGE-2 all -- anywhere anywhere
    RETURN all -- anywhere anywhere

    Chain DOCKER-ISOLATION-STAGE-2 (4 references)
    target prot opt source destination
    DROP all -- anywhere anywhere
    DROP all -- anywhere anywhere
    DROP all -- anywhere anywhere
    DROP all -- anywhere anywhere
    RETURN all -- anywhere anywhere

    Chain DOCKER-USER (1 references)
    target prot opt source destination
    RETURN all -- anywhere anywhere


  • Options
    ZSzatmariZSzatmari Employee, Member Posts: 13 RM Engineering
    Our RapidMiner Server AWS Marketplace AMIs (images) are prepared with PostgreSQL as a RapidMiner Server database backend, but it is only for the RapidMiner Server own management data storage. You should be able to connect to any existing MS SQL server as database from any RapidMiner processes. If you have an external MS SQL database, then there is no firewall restriction on the RapidMiner Server cloud image side for any outgoing connection. If you experience any connection issues, then we propose to check your instance's networking setup in AWS (security gorup, subnet settings, IGW, etc...) and the networking/firewall setup of your MS SQL database.
Sign In or Register to comment.