Setting up a Push from your database to ipushpull

This article explains how to push data from your local databases into ipushpull so you can access it across all our client apps and share it with your colleagues and customers. These are the steps to take:

  • Configure your data source

  • Select the ipushpull page you want to push your data to

  • Configure the SQL query that will extract the data from your database

  • Apply styles and formatting to your data

  • Save your configuration

 1. Set up the DataLoader and connect your database

See this article to find out how to install the DataLoader, login and configure your data sources. 

2. Configure a Push

The DataLoader lets you configure multiple pushes in a single saveable config. Here's how to set up your first push:


a. Enter a name for this push in the Name field (this can be anything - it's for your own reference).

b. Choose the Folder and Page for the Page you want to push the data into using the dropdowns. In this case the folder is called Demo and the page is called DBDemo:


c) Choose your data source from the dropdown and enter the SQL query you want to run (we suggest you paste the query in from the DB dev tool you are using). In this case we are using an MS SQL Server database:

d) Tick the Headers checkbox if you want to push the header row from your query results to your ipushpull page.

e) To select data from your db and push it once, click the Push button

f) 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.

3. Example Query Config

Here's a sample configuration for pushing data into the page Demo/DBDemo every 30 seconds:


Once you're happy with your configuration, press the Start button to start pushing. Your data will appear in ipushpull and update each time the query is run:


4. Style and format your data

By default the DataLoader pushes data without any formatting and styling. You can 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.

The easiest way to create a format page is to set the formats up in Excel then paste them into ipushpull. Here's an example of a formatted range in Excel - dark blue header, with alternate shades of blue for the content rows. The first column is right justified, and is narrower than the others.

 Once you're happy with this, paste it into your formats page in ipushpull

 Now update your DataLoader config to specify this Format Page (you will have to pause updates while you do this):

 Restart and you will see that your data page is now formatted the way you specified:

5. Save your configuration

Once you're happy with your configuration, select File | Save so you can return to it later.

6. Configuration Reference



Example Value



Example Value


(Optional) Name for this query



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



The ipushpull page you want to push the data to



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


Format Folder

The ipushpull folder containing the format template page


Format Page

The ipushpull page where styles and formats will be copied from


Data Source

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


Data Query

The SQL query that you want to run against your database

SELECT * FROM demo_table


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



How frequently the query should be run (seconds)


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