Let's assume an Intuit QuickBase sample table like this:
Fig.: QuickBase sample table to connect via Layer2 Cloud Connector.
In this example we connect to QuickBase via QNect ODBC. QNect needs to be installed and configured locally as follows. Be sure that your System DSN ODBC connection works as expected before go next steps.
Fig.: Sample QNect ODBC Configuration to make use of it in the Layer2 Cloud Connector.
To connect 100+ external data sources to QuickBase, the data entity must be configured as follows in the Layer2 Cloud Connector Connection Manager:
Fig.: Sample connection configuration to connect and external sync data with QuickBase.
Please note the following specific settings.
- Please select the ODBC Data Provider to connect to your pre-configured DSN.
- You can refer to your ODBC DSN a connection string like this:
- All data queries are supported as your QNect driver understands. Note the table ID insted of the name (looks like a QNect issue).
- You can map your QuickBase data fields to specific external fields in the Layer2 Cloud Connector. Please take care about data types (simple type conversions are supported). If fields are not available, please check your view.
- The QUickBase primary key must be set manually as shown in the form above. It must also be mapped to allow inserts. Make sure to assign 0 values. In our tests other values, or empty (non-mapped) fields did not work as expected.
- You can use the connection for uni- or bi-directional synchronization.
- No installation or changes are required at the data source (QuickBase) or data destination, e.g. on SharePoint or Office 365.
- Data synchronization can be started manually in the Connection Manager, per command line or scheduled in background by the Layer2 Cloud Connector Windows Service. Only data changes are processed (no delete / bulk import).
- No programming required for setup a connection and sync.
- No need to open your local network for access from outside.