Explains what the feature is or what its benefits are to the user or customer.
Use JDBC to connect to the Falcon Simba server from Pentaho. The connection will be made between a new Falcon Table Input and Output objects.
You can download these files from the Help Center.
To set up the JDBC driver using Pentaho:
- Open the PDI client. You may use the command:
./spoon.sh &>/dev/null &
- Right click Transformations in the left View tab, and click New to create a new transformation.
- Click Input under the Design tab to expand it, and drag and drop CSV File Input to the Transformation window. This will bring in a new CSV file.
- Double click the CSV File Input icon to open the CSV Input dialog box.
- Name the Step. Then click Browse next to the Filename field to provide the file you want to read from. Once you have selected the file, click OK.
- In the CSV Input dialog box, click Get Fields.
- Enter the number of lines you would like to sample in the Sample size dialog box. The default setting is 100. Click OK when you are ready.
- Click Preview to preview the data.
- Enter the number of rows to preview in the Preview size dialog box. The default setting is 1000. Click OK to start the transformation in preview.
- Examine the preview data, then click Close. You may want to verify that you are able to read the data using the SQL query from Falcon.
- Click OK in the CSV Input dialog to confirm your CSV input settings.
- Click Output under the Design tab to expand it, and drag and drop Table output to the Transformation window.
- Double click the Table output icon to open the Table output dialog box.
- Name the step. Then click New to create a new connection.
- Enter or select the following information in the Database Connection dialog box:
- Connection Name
- Connection Type: Generic database
- Access: Native (JDBC)
- Custom Connection URL: jdbc:simba://<server_ip>:12345;Database=<database_name or schema_name>
<server_ip> is the IP of your Falcon cluster. <database_name> is the name of the database you want to connect to. Use TQL to create a database name if needed.
- Custom Driver Class Name: com.simba.client.core.jdbc4.JDBC4DriverNote: Please ensure that there are no leading or trailing spaces in the Custom Connection URL and the Custom Driver Class Name fields. JDBC will get confused if there are any such spaces, and as a result, will not be able to establish a connection.
- User Name and Password
The User Name and Password are your ThoughtSpot credentials, but you can elect to keep these fields empty.
- Click Test to test your database connection. If you are able to make a successful connection to the Falcon Simba Server, click OK.
- Click OK in the Database Connection dialog box to create the new connection.
- In the Table output dialog box, select the connection you just created.
- Click Browse next to the Target schema field, the select your Target schema. Click OK when you are done.
- Connect the Input CSV icon to the Table output icon by clicking and dragging an arrow. When prompted, choose Main output of step.
- Double click the Table output icon to reopen the Table output dialog box.
- Enter a Target table name. Then click SQL.
- In the Simple SQL editor dialog box, click Execute to see the results of the SQL statements.
- Close all open dialog boxes.
- Click the Play button at the top of the Transformation window to execute the transformation.
- Click Launch in the Execute a transformation dialog box.
- You will be asked to save it if you have not already.
- View the Execution Results.