You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

BellaDati can be connected to numerous Databases.

Please consult with support particular solutions.

Connecting to Database

From Data Source Connectors page select SQL Database Connector.

Connection Parameters

You must specify following parameters:

  • host: IP address or domain name
  • database (SID): database name
  • password
  • user

Additional parameters can be specified by clicking on Add link in bottom left part of Connection parameters window. They can include:

  • port
  • driver: If different drivers are required for various database versions, you can select the right version here (eg. Oracle).

Connection parameters above may vary according 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 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.

Supported Databases

Depending on application usage (cloud or On-Premise) BellaDati is able to connect to these SQL databases:

Name

Supported versions

Driver versions

Oracle

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

MySQL

3.1.3 or higher

5.1.13

PostgreSQL

8 or higher

9.0-801-jdbc4

Microsoft SQL Server

MSSQL 2008, MSSQL 2008 R2, MSSQL 2008 Express

sqljdbc4

SAP Max DB

7.3 or higher

7.4.4 Build 003-000-002-502

Database support varies by BellaDati Cloud tariff or On-Premise integration environment.

Defining Query

Query window will be presented after successful connection. Click Set Parameters to specify SQL query.

Enter desired SQL query into opened dialog and click OK.

BellaDati will open Import Settings page. Continue with Data Sets to finish import.

Conection Modifications

Following data source parameters can be modified within the existing data source in Data Set page:

  • 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.

Tutorial video

Next Steps

  • No labels