With the Retrieve operator selected, you can then define which table to retrieve in the Parameters view by clicking the folder icon next to the "repository entry." In the resulting Repository Browser, you can expand your connection node to select the desired example set.įinally, wire the output to the Retrieve process to a result, and run the process to see the Excel data. To retrieve Excel data, drag the Retrieve operator from the Operators view. You can now use your Excel connection with the various RapidMiner operators in your process. Enter your username and password if necessary.Either double-click the JAR file or execute the jar file from the command-line.įill in the connection properties and copy the connection string to the clipboard.Įxcel File='C:/MyExcelWorkbooks/SampleWorkbook.xlsx' The ExcelFile, under the Authentication section, must be set to a valid Excel File.įor assistance in constructing the JDBC URL, use the connection string designer built into the Excel JDBC Driver. Enter your connection string in the Host box.For Database System, select the Excel driver you configured previously.Create a new Excel connection: Click Connections -> Manage Database Connections.'To truly build trust, don’t focus only on explaining the model. RapidMiner provides a central source of truth for your projects, makes results tangible and easy to understand, and simplifies Model Ops so you can generate real business impact and maximize value over time. Enter the path to the file, located in the lib subfolder of the installation directory. Break down silos and build trust in data science solutions. In the resulting wizard, click the Add button and enter a name for the connection.Add a new database driver for Excel: Click Connections -> Manage Database Drivers.You can follow the procedure below to establish a JDBC connection to Excel: This article uses the CData JDBC Driver for Excel to transfer Excel data to a process in RapidMiner.Ĭonnect to Excel in RapidMiner as a JDBC Data Source This article shows how you can easily integrate the CData JDBC driver for Excel into your processes in RapidMiner.
0 Comments
Leave a Reply. |