Send Live & Streaming Data from your Database

This article explains how you can set up Live and Streaming Data from your Database using the ipushpull DataLoader.

1. Sign up for ipushpull and install our DataLoader

First, make sure you or your account admin have signed up to ipushpull. Then follow the instructions in this article to install the DataLoader. 


2. Login and Connect your Database

Launch the ipushpull Data Loader and click the Login to ipushpull option from the menu. Enter your email and password and press Login.

Click the Configure Database Connection button to connect your database or file. Choose your database below:


4. Configure your database query and push the results to ipushpull

Now configure your SQL query and the ipushpull page to send the results to. For full details see Setting up a Push from your database to ipushpull.

Here’s an example configuration:

Fields used in above example:

Field

Description

Example Value

Field

Description

Example Value

Name

(Optional) Name for this query

Demo

Folder

The ipushpull folder containing the page you want to push the data to

DemoFolder

Page

The ipushpull page you want to push the data to

DemoPage

Formats:

Toggle controlling whether or not you want to apply styles and formats to the data

Yes

Format Folder

The ipushpull folder containing the format template page

DemoFolder

Format Page

The ipushpull page where styles and formats will be copied from

DemoFormat

Data Source

The name of the data source you want to run the query against

DemoDBSource

Data Query

The SQL query that you want to run against your database

1 SELECT * FROM demo_table

Headers

Toggle controlling whether or not to push the data headers/column names to your ipushpull page

Yes

Interval

How frequently the query should be run (seconds)

60

Push Button

Run the query once and push the data to your page

 

Start Button

Start periodically pushing the data to ipushpull, according to the interval you set

 

Web Button

Launch the ipushpull website and display the page

 

Push Status

Status message showing whether the push was successful or not

 


5. Push your data to your ipushpull page

To push the data manually once, click the Push button

or to start the query to run periodically at a specified interval, enter your interval (in seconds) in the Interval field and click Start.

A message indicating whether or not your push was successful will be displayed in the Push status field. 


6. Save your configuration

Finally select File | Save to save your configuration for future use.


Additional Style and Formatting Information

The Data Loader pushes data without any formatting unless you configure it to add styling & formats. You style your data by specifying a format page. The colours, styles, column widths etc. will be copied from the format page and applied to your data. See this page for full details.