Supported databases
Depending on application usage (cloud or on-premise) BellaDati is able to connect to these SQL databases:
Name |
Supported versions |
Driver versions |
---|---|---|
|
10.1.0.5, 10.2.0.1-10.2.0.5, 11.1.0.7, 11.2.0.1, 11.2.0.2 |
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 or higher |
5.1.13 |
|
8 or higher |
9.0-801-jdbc4 |
|
MSSQL 2008, MSSQL 2008 R2, MSSQL 2008 Express |
sqljdbc4 |
|
7.3 or higher |
7.4.4 Build 003-000-002-502 |
Database support varies by BellaDati Cloud tariff or On-Premise integration environment.
Connection to many more database vendors is possible using general JDBC drivers. Please consult our support about particular solutions.
Tutorial video
Connection parameters
You must specify the following parameters:
- host: IP address or domain name
- port
- database (sid): database name
- user
- password
- driver: If different drivers are required for various database versions, you can select the right version here (eg. Oracle).
Additional parameters can be specified.
Connection parameters above may vary according the database vendor. Please, refer to your database vendor`s documentation for details.
Connection to the database will be checked immediately - if a problem arises, you will be informed via error message. Please also check the 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.
In the next step, provide the SQL command to load the data.
Modifications
Following data source parameters can be modified within the existing data source via data set summary:
- Connection parameters
- SQL statement
When changing SQL query to extract more columns from the database, use Reset values function and then perform new import settings; otherwise the additional columns will not be imported.
Next Steps
- Take me back to data sources
- Import settings
- Scheduling Import