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
"Using System DSNs to conect to a database"
Learner III
I'm trying to evaluate Rapid Miner, but I can't get it to connect to my database. We're using MS SQLServer over named pipes connections using Windows Integrated security. This meas I can't just ODBC into the database with a port number and username/password connection. Normally I use system DSNs to make ODBC connections, and this works just fine in MS Access or Excel. However, I can't figure out where in Rapid Miner to reference the DSN.
The article on the wiki seems to suggest it is possible, but basically tells me how to create a DSN (which I already know) and not how to see that DSN in RapidMiner. For example, what is the DatabaseExampleSource and how do I set it? The link has no information!
http://rapid-i.com/wiki/index.php?title=Microsoft_Access
When I use the Manage Database Connections tab and the ODBC Bridge option it still asks for loads of information (port number, schema, username and password) all of which should not be required as they are defined in the DSN. Any help appreciated.
The article on the wiki seems to suggest it is possible, but basically tells me how to create a DSN (which I already know) and not how to see that DSN in RapidMiner. For example, what is the DatabaseExampleSource and how do I set it? The link has no information!
http://rapid-i.com/wiki/index.php?title=Microsoft_Access
When I use the Manage Database Connections tab and the ODBC Bridge option it still asks for loads of information (port number, schema, username and password) all of which should not be required as they are defined in the DSN. Any help appreciated.
Tagged:
0
Answers
you can use the Read Database operator. If you choose url on the parameter define connection, you can enter an arbitrary connection string. Usually connecting to a DSN should work like this: .
Username and password should be the ones of your database account. And finally enter a querry or select a table name. If this does'nt work, please send me the exact error message. I will then see, what I can do for you.
Greetings,
 Sebastian