Ready to get started?

Learn more about the CData JDBC Driver for FedEx or download a free trial:

Download Now

Connect to FedEx Data in RapidMiner

Integrate FedEx data with standard components and data source configuration wizards in RapidMiner Studio.

This article shows how you can easily integrate the CData JDBC driver for FedEx into your processes in RapidMiner. This article uses the CData JDBC Driver for FedEx to transfer FedEx data to a process in RapidMiner.

Connect to FedEx in RapidMiner as a JDBC Data Source

You can follow the procedure below to establish a JDBC connection to FedEx:

  1. Add a new database driver for FedEx: Click Connections -> Manage Database Drivers.
  2. In the resulting wizard, click the Add button and enter a name for the connection.
  3. Enter the prefix for the JDBC URL: jdbc:fedex:
  4. Enter the path to the cdata.jdbc.fedex.jar file, located in the lib subfolder of the installation directory.
  5. Enter the driver class: cdata.jdbc.fedex.FedExDriver
  6. Create a new FedEx connection: Click Connections -> Manage Database Connections.
  7. Enter a name for your connection.
  8. For Database System, select the FedEx driver you configured previously.
  9. Enter your connection string in the Host box.

    There are five pieces of information needed in order to authenticate its actions with the FedEx service. This information is below.

    • Server: This controls the URL where the requests should be sent. Common testing options for this are: "https://gatewaybeta.fedex.com:443/xml", "https://wsbeta.fedex.com:443/xml", "https://gatewaybeta.fedex.com:443/web-service", and "https://wsbeta.fedex.com:443/web-service"
    • DeveloperKey: This is the identifier part of the authentication key for the sender's identity. This value will be provided to you by FedEx after registration.
    • Password: This is the secret part of the authentication key for the sender's identity. This value will be provided to you by FedEx after registration.
    • AccountNumber: This valid 9-digit FedEx account number is used for logging into the FedEx server.
    • MeterNumber: This value is used for submitting requests to FedEx. This value will be provided to you by FedEx after registration.
    • PrintLabelLocation: This property is required if one intends to use the GenerateLabels or GenerateReturnLabels stored procedures. This should be set to the folder location where generated labels should be stored.

    The Cache Database

    Many of the useful tasks available from FedEx require a lot of data. To ensure this data is easy to input and recall later, utilizes a cache database to make these requests. You must set the cache connection properties:

    • CacheProvider: The specific database you are using to cache with. For example, org.sqlite.JDBC.
    • CacheConnection: The connection string to be passed to the cache provider. For example, jdbc:sqlite:C:\users\username\documents\fedexcache.db

    Built-in Connection String Designer

    For assistance in constructing the JDBC URL, use the connection string designer built into the FedEx JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.

    java -jar cdata.jdbc.fedex.jar

    Fill in the connection properties and copy the connection string to the clipboard.

    A typical connection string is below:

    Server='https://gatewaybeta.fedex.com:443/xml';DeveloperKey='alsdkfjpqoewiru';Password='zxczxqqtyiuowkdlkn';AccountNumber='110371337';MeterNumber='240134349'; PrintLabelLocation='C:\users\username\documents\mylabels';CacheProvider='org.sqlite.JDBC';CacheConnection='jdbc:sqlite:C:\users\username\documents\fedexcache.db';
  10. Enter your username and password if necessary.

You can now use your FedEx connection with the various RapidMiner operators in your process. To retrieve FedEx data, drag the Retrieve operator from the Operators view. 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.

Finally, wire the output to the Retrieve process to a result, and run the process to see the FedEx data.