It's as easy as copy & paste! Copy the Oracle Database Select Web Part source to your clipboard, paste that source into the RSSBus Web Part source editor, and click 'Apply'. Click on the details tab for more information.
Prerequisites
RSSBus Web Part Templates require RSSBus for SharePoint™ to be installed
into your SharePoint Portal (MOSS) or SharePoint Services (WSS) Site. Some templates may also require additional connectors.
Maybe the best way to get an idea of what the RSSBus SharePoint Web Part™ does
and how it functions is to watch a quick video that describes the main features.
Trying to modify this template for a specific task?
We have qualified professionals standing by that can quickly go from your idea
to a ready-to-run RSSBus Web Part Template. Contact us now:
support@rssbus.com
Web Part Usage
Click the "Copy to Clipboard" button which is located in the "Download" tab.
If you haven't already, add a new RSSBus Web Part to your SharePoint page.
In SharePoint, on your new RSSBus Web Part properties pane, click the "Source Editor" button to open the editor.
Paste the clipboard contents into the RSSBus Web Part Source Editor and click "Apply".
The following inputs will be listed in the RSSBus Web Part properties pane, where you can set their values appropriately and click "Apply" again.
Web Part Inputs
Name
Description
Required
table
The table to select from
yes
cols
The columns to select from the table
yes
maxrows
The Max number of rows to return (-1 is used to return all rows)
no
Additional Requirements
This template requires you to install RSSBus.OracleOps. Note: The Oracle connecter requires you install the "Oracle Client" on the same machine that sharepoint resides.
Full Size Preview
Click here to see a full size preview of this Web Part.
Web Part Download
This Web Part requires the installation of the pre-requisite items listed below. If you already have these items
installed, then you can download the Oracle Database Select Web Part to a file or copy the Web Part mark-up directly to your clipboard.
Want to learn how easy it is to create Web Parts like this one with the RSSBus SharePoint Web Part? You can
view the Web Part source to review the mark-up
that enables this Web Part.
Prerequisites
RSSBus Web Part Templates require RSSBus for SharePoint™ to be installed
into your SharePoint Portal (MOSS) or SharePoint Services (WSS) Site. Some templates also require additional connectors.
<rsb:import lib="RSSBus.OracleOps"/>
<rsb:info>
<input name="table" description="The table to select from" required="true" default="EMPLOYEES" />
<input name="cols" description="The columns to select from the table" required="true" default="FIRST_NAME,LAST_NAME,PHONE_NUMBER,JOB_ID" />
<input name="maxrows" description="The Max number of rows to return (-1 is used to return all rows)" default="-1"/>
</rsb:info>
<rsb:set attr="conn" value="Data Source=DatabaseIP;User Id=hr;Password=hr"/>
<rsb:call op="oracleSelect" format="yuitable"/>
Related Web Parts
Listed below are a few more Web Parts that are similar to the Oracle Database Select Web Part selected above.
This Web Part template shows how to generate a multi series column chart using CSV data. This is accomplished by taking advantage of one of the many feed formatters available with RSSBus.
This Web Part template shows how to generate a multi series spline chart using CSV data. This is accomplished by taking advantage of one of the many feed formatters available with RSSBus.
This Web Part selects sales by country from SQL and displays the results in a YUI Data Table and a Bar Chart. To use this, paste the source into the RSSBus Web Part source editor and edit the connection [...]
Videos & Technical Resources
Find our more about how the RSSBus SharePoint Web Part can help you quickly and easily integrate your SharePoint
sites with internal and external data sources including databases, applications, and services:
The Case For Simple Services
Discover RSSBus Simple Services™ and learn how to enhance current services
architectures with highly flexible data services.
RSSBus SharePoint Web Part™ - Formatting
with HTML
This video shows how to use RSSBus SharePoint Web Part to connect and retrieve records
from a Microsoft SQL database, and format the Web Part output as an HTML table.
RSSBus SharePoint Web Part™ - Service
Enablement
Use SharePoint Server as a Simple Web Services Platform. Extend SharePoint with
Simple Services and use SharePoint to manage service accessibility.
RSSBus QuickStart
Guide
A hands-on introduction to the concepts and usage of RSSBus Desktop and RSSBus Server.
RSSBus SharePoint Web Part™
RSSBus OracleOps Connector
