ParaSQL Release 31 **Hyper Connect Engine** is now available!

[ParaSQL Support]

New In ParaSQL Release 31 (January 30 2016)

• Hyper Connect Engine (beta 1):
  • This is the initial beta release of Hyper Connect Engine. Hyper Connect allows you to connect to tables from remote data sources and work with them in a ParaSQL app almost as though they were local database tables. You can view, add, edit and delete data, and join tables regardless of if they are local or remote. (There is a video overview of Hyper Connect at minute 7:30 of The Power of ParaSQL video here).
  • Hyper Connect currently supports connections to remote MySQL, Cloud SQL, and MariaDB databases as well as remote Microsoft SQL Server, Azure, and Sybase databases.
  • You will need to contact ParaSQL support to apply for a Hyper Connect testing account while it is in beta.
  • Once you have been set up on a Hyper Connect account, you may use Tools > Data Sources...to establish a data source and test its connection. After a data source has been tested successfully, you may click the Create Table icon on the Palette, then select Table Connected From Data Source and follow the prompts.
  • Connected tables are displayed in orange on the Palette.
  • When you first create a Connected table, it will not have any Primary Key info. Click Modify Table on the Palette and read the Help to add a Virtual Primary Key and/or Virtual Foreign Key(s) as needed. You will not be able to edit a Connected table without a Virtual Primary Key.
  • Hyper Connect supports WHERE clause push-down; this means that when accessing the remote server only those rows that match the WHERE clause are retrieved. If your remote table contains many rows, be certain to structure your apps so that they limit the rows retrieved in all cases. Currently, when JOINing local and remote tables where only the local table contains a WHERE clause restriction the entire remote table is retrieved to perform the join. In the near future you will be able to specify an alternate optional behavior where only the matching rows for the join are retrieved.
• Browser Back Button Support. You can now navigate backward through prior tab and menu selections within an app using the browser's back button.
• Deleting a user no longer deletes the apps that they own. Now if a user is deleted that owns apps, the ownership of those apps is transferred to the super administrator of the account.
• More efficient Data Links. Data Links to objects that are not visible are now postponed until they become visible.
• New user interface for Security Roles. See Tools > Security Roles... for details.
• Support for Editable Views. You can now perform a CREATE VIEW on the server and annotate it with Virtual Keys within ParaSQL. VIEWs are displayed in blue on the Palette and Security Roles panel. Single table VIEWs with a Virtual Primary Key designated within ParaSQL are editable, including support for AutoKey generation.

[Hajar Homayouni]

Hi,

Can I connect to ParaSql database from other applications? Actually I have a R application that I want to query both Google Big Query and Cloud Sql at the same time (with a single connection). can I instead connect to ParaSql ?

Thank you.

[Robert Dyas]

Yes, the database under ParaSQL is *FULLY* accessible from other apps that can work with a MySQL compatible database. Both Google Cloud SQL and ParaSQL's Hyper Connect Engine are fully MySQL compatible, so you can use open source MySQL ODBC and JDBC drivers to access them directly. Note that we support the standard open source ODBC and JDBC drivers - no need for anything proprietary.