Ready to get started?


Learn More

Access Reckon Data in PHP through the Cloud Hub

Connect to Reckon through the standard MySQL libraries in PHP.

You can use the CData Cloud Hub to access Reckon data from MySQL clients, without needing to perform an ETL or cache data. Follow the steps below to create a virtual MySQL database for Reckon and connect to Reckon data in real time through PHP's standard MySQL interfaces, mysqli and PDO_MySQL.

The CData Cloud Hub provides a pure MySQL, cloud-to-cloud interface for Reckon, allowing you to easily query live Reckon data in PHP — without replicating the data to a natively supported database. As you query data in PHP, the CData Cloud Hub pushes all supported SQL operations (filters, JOINs, etc) directly to Reckon, leveraging server-side processing to quickly return Reckon data.

Create a Virtual MySQL Database for Reckon Data


  1. Login to Cloud Hub and click Databases.
  2. Select "Reckon" from Available Data Sources.

With the virtual database created, you are ready to connect to Reckon data from any MySQL client.

Connect in PHP


  • Password: Specify the password for the authorized user account.
  • Database Name: Specify the name of the virtual database you created for Reckon.


$mysqli = mysqli_init();


$mysqli->real_connect("mysintance.cdatacloud.net", "admin", "mypassword", "reckondb",3306,NULL,MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT);


$pdo = new PDO('mysql:host=myinstance.cdatacloud.net;dbname=reckondb;port=3306;','admin', 'mypassword', array(

Query in PHP


  1. Query the table; for example, Customers. The results will be stored as an associative array in the $result object.
  3. Close the connection.


$result = $mysqli->query("SELECT Name, CustomerBalance FROM Customers");
    echo "$k : $v";
    echo "<br />"; 


$result = $pdo->query("SELECT Name, CustomerBalance FROM Customers");
    echo "$k : $v";
    echo "<br />"; 
$result = null;
$pdo = null;