BellaDati can be connected to numerous Databases.
Please consult with support particular solutions. |
From Data Source Connectors page select SQL Database Connector.
Depending on application usage (cloud or On-Premise) BellaDati is able to connect to these SQL databases.
Support for database not listed below can be added on-demand. |
Name | Supported versions | Driver versions | Note |
---|---|---|---|
| 10.1.0.5, 10.2.0.1-10.2.0.5, 11.1.0.7, 11.2.0.1 -11.2.0.4, 12.1.0.1, 12.1.0.2, 12.2.0.1 | v6-11.1.0.7, v6-11.2.0.1, v6-11.2.0.2, v14-10.1.0.5, v14-10.2.0.1, v14-10.2.0.2, v14-10.2.0.3 ,v14-10.2.0.4, v14-10.2.0.5 | |
| 3.1.3 and higher | 5.1.13 | MySQL 8 is supported from BellaDati 2.9.19.2. |
| 8 and higher | 9.0-801-jdbc4 | |
| MSSQL 2017, MSSQL 2018 | sqljdbc6.2.2.jre7 | |
| 7.3 and higher | 7.4.4 Build 003-000-002-502 | |
SAP HANA | all | SAP In-Memory Database JDBC Driver, 1.00.48 Build 0372847-1510 | |
Hadoop Hive | Hadoop 2 and higher | 2.3.3 | |
Cloudera Impala | 5 and higher | 2.5.31.1051 | |
Microsoft Access | all | Java SE JDBC/ODBC | Scheduled import is not supported. Before each import, the file has to be selected again. |
Sybase | all | jconn4 | |
Teradata | 11 and higher | terajdbc4 | |
Vertica | 8.1 and higher | 9.2.x | |
Firebird | Jaybird 2.2.7 | ||
Custom | Supported in BellaDati 2.9.6.2 and newer. Usable when a custom connection string is needed or user provides own JDBC driver to the application server. two mandatory fields:
Example:
|
Database support varies by BellaDati Cloud or On-Premise integration environment. |
Connection parameters may vary depending on the selected database vendor. Most common parameters are the following
Additional parameters can be specified by clicking on Add link in bottom left part of Connection parameters window. They can include:
For connection via SSH Tunnel, following parameters have to be added:
Connection parameters above may vary according database vendor. Please, refer to your database vendor`s documentation for details or see the Connection parameters examples for examples. |
Connection to the database will be checked immediately - if a problem arises, you will be informed via error message. Please also check your firewall settings - if BellaDati can connect to the data source.* |
Direct connection using localhost keyword or localhost IP address is disabled due to security reasons. Please define an alias in hosts file (eg. C:\WINDOWS\system32\drivers\etc in Windows). Than use this alias in BellaDati. |
If you cannot connect to your database, please verify:
systemctl restart sshd.service
# Settings that override global settings for matching IP addresses.Match statement must be at the end of the file. Users from IP below need only password for ssh authentication not private/public keys Match address 192.168.168.1,192.33.54.1 |
Still having problems with connection to your SQL database? Please navigate to separate page focused on troubleshooting of this issue. |
There are two options how to query database:
Database Discovery is a visual editor for specifying database queries. To obtain data from the your database:
BellaDati will construct corresponding SQL query in the right SQL window |
For advanced users or queries, BellaDati offers SQL Query Window. Use Query Window to construct desired SQL commands (SQL query with join, stored procedures, etc.).
Click validate button to make sure that your command is correct before proceeding with data mapping. |
You can also use stored procedures for data import. Stored procedures should have syntax like following:
execute [db].[sp]
@BegDate = '2015-07-01'
,@EndDate = '2015-07-31'
Where [db] is the name of the database, [sp] is the name of the stored procedure, @BegDate and @EndDate are parameters used by stored procedure.
Following data source parameters can be modified within the existing data source in Data Set page:
When changing SQL query to extract more columns from the database, use Get new columns function - this function adds new columns and preserves previous settings. Otherwise the additional columns will not be imported. Second option is use of Reset function. This function resets previous settings and adds new columns. You need to setup new import settings in this case. Otherwise the additional columns will not be imported. |
<iframe width="560" height="315" src="https://www.youtube.com/embed/660cFs89riU" frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe> |