Manual - SQLConnector

SQL Connector.png

SQLConnector

Notes

  • This connector requires knowledge about databases and queries. A few examples are listed below to make a quick start.

Configuration in CRM application

The database administrator needs to create a database account with read permissions for the database you want to query.

Configuration Bubble Software

Login as the user in the Bubble software. Go to CRM Connectors in the navigation bar on the left side, select the desired CRM integration by double clicking on it (please note that a CRM-application is activated if it has a blue frame around it).

7b84ef59-c6d1-4aef-a466-128dbb25d32c.png

MySQL / MS SQL

Note: when using the MS SQL database, please make sure you are using SQL server authentication. Windows authentication is not supported. Also disable the checkbox "User must change password at next login.".

653fdd55-2f45-4af0-8d9e-0fd7a53719e0.png

Build your own query to retrieve data from your table(s). In the query it is possible to specify the $number and other $number-notations (see Legend). If the checkmark 'Try different number notations for $number' is enabled, Bubble will run the query multiple times for all number notations that are generated.

In the example above the query will run as follow:

SELECT * FROM contacts WHERE phone='$number' OR cell='$number'
SELECT * FROM contacts WHERE phone='+31612345678' OR cell='+31612345678'
SELECT * FROM contacts WHERE phone='0031612345678' OR cell='0031612345678'
SELECT * FROM contacts WHERE phone='0612345678' OR cell='0612345678'
SELECT * FROM contacts WHERE phone='06 12345678' OR cell='06 12345678'
and a few more...

All results will be merged in a multi-result popup.

ODBC

Microsoft Access. You need to install the Microsoft Access ODBC driver.

Connection string:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\my_database_file.accdb;Jet OLEDB:Database Password=MyDbPassword;

Query example:

SELECT * FROM contacts WHERE nummer = '$number'


Easy roll out to other users

With the Clone Profiles module under the tab Bubble (in your partnerportal portal.redcactus.nl) it is possible to roll out a configuration to all selected people at the same time. This gives you as much configuration time for 1 user as for 1,000 at the same time. Please note, this is an exact copy of the profile. Check knowledgebase ( Clone Profiles )



Index

SQLConnector

Configuration in CRM application
Configuration Bubble Software
MySQL / MS SQL
ODBC
Easy roll out to other users

Features

Outbound call possibilities CRM

Click to dial from CRM
Start an outgoing telephone call with one mouse click from your CRM application or any website.

Hotkey dial from CRM
Is a phone number not clickable in your CRM? With this function you can still make a call.


Integration features

Multi result pop-up
Does a phone number occurs multiple times in your CRM application? Click directly to the next result. Do you need this feature but is it not yet available for your integration? Please contact us.

Call registration
Call information can be recorded directly in your CRM under the customer card. Do you need this feature but is it not yet available for your integration? Please contact us.

Custom field variables
The custom fields that have been created in the CRM application yourself can also be used to display in the pop-up.

SearchBar
Search CRM contact information from the 'SearchBar' desktop toolbar. From here you can open the customer card, start a phone call directly, send an email/WhatsApp/Microsoft Teams message or view the call history. Do you need this feature but is it not yet available for your integration? Please contact us.


Integration type

Database connection
Data exchange via direct database access.


Pop-up type

Bubble pop-up
Make use of all the functionalities that Bubble has to offer you


Action Buttons

CRM specific buttons
CRM specific buttons to, for example, open customer card or initiate other actions. See tab 'buttons'.

Quick search (clipboard copy)
The CRM application you use is limited in telephony integration functionalities and does not support opening a customer card via a button in an external application such as Bubble. For this integration is the copy to clipboard functionality that directly copies the customer name or customer number to your clipboard so that you can use it to quickly search in your CRM application.


Standard Bubble pop-up functions

Remote Dialer
A remote dialer is always available on your desktop so that you can start a call quickly and easily.

Pop-up notification
With an incoming, outgoing and forwarded call, an immediate notification with customer information.

Content pop-up customization
Determine the content of the pop-up per user, department or organization with info from your CRM application.

Screen & position customizable
Working with multiple screens? Decide at which screen and in what position you want to see the pop-up.

Single sign-on
No need to remember multiple passwords, login with your Microsoft, Google or Apple account.

Auto-hide
Indicate whether you want the pop-up to remain or to disappear automatically after x time or action.

Multi-languages
Determine the language of the content in the pop-up by adding the words in the language of your choice.

Mute
Mute the pop-ups for a while? Mute the notifications with a simple mouse click until you turn them on again.

Hide internal callers
Don’t want to see a pop-up when a colleague calls you internally? Possibility to turn this function on or off.

Sorting result
Prefer to show contacts first instead of companies when using ‘multi-result’? Decide the order yourself.

Callback request button
No more typing callback requests, but emailing the customer data directly to your colleague via a button

Email button
Do you want to send the caller an email during a telephone conversation? Activate then this button.

To copy button
With the copy function, you have a button that allows you to directly copy data to your clipboard.

Custom action button
Do you have other wishes? Configure a custom button to your liking (e.g. call a specific URL or an .exe)

Click to dial
Start an outgoing telephone call with one mouse click from any website.

Hotkey dial
Is a phone number not clickable in your CRM? With this function you can still make a call.

Recall conversations
In one click, the completed conversation popups can be retrieved to show the information again.

Call back
You can recall the phone number again directly from a ‘retrieved pop-up’ with a simple mouse click.

Talk duration timer
During a phone call, a timer is visible in the pop-up where the duration is displayed in seconds.

Call history
Display the name of the colleague who last spoke or tried to call the caller in the past 3 months.

Call notes
Immediately record your conversation info in a note so that all information is visible to your colleagues.

Multi-tenant mode
With this function you are able to be logged in with multipleaccounts at the same time from one workplace.

Multiple profiles
You can configure multiple profiles so that you as a user are able to switch quickly to another profile.

Updates
With a Bubble license you are always entitled to the latest functions that can be installed with one click.

Native Windows applicatie
Bubble is available as a native software application for Windows.

Native macOS applicatie
Bubble is available as a native software application for macOS


Buttons

Below is the list of available buttons. These are both CRM specific- and generic Bubble functions. Think about invoking a specific URL or script, opening an e-mail or making a callback request. Call Control is only available if your telephony platform supports it.

  • Custom Action (standard button)
  • Send E-mail (standard button)
  • Callback request (standard button)
  • Call Control (standard button)*
  • Send WhatsApp message (standard button)
  • Send Microsoft Teams message (standard button)
  • Open SearchBar (standard button)

Parameters

Determine the content of the pop-up per user, department or organization with information from your CRM package. Below is the list of parameters available from your CRM software.

  • All data from the database
Copyright Red Cactus B.V. © 2020 - 2023 Terms and conditions