BellaDati can be connected to numerous Databases.
Connecting to Database
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.
10.1.0.5, 10.2.0.1-10.2.0.5, 188.8.131.52, 184.108.40.206 -220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199
v6-188.8.131.52, v6-184.108.40.206, v6-220.127.116.11, 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
8 and higher
MSSQL 2008, MSSQL 2008 R2, MSSQL 2008 Express, MS SQL Server 2012, MS SQL Server 2014 and higher
7.3 and higher
7.4.4 Build 003-000-002-502
SAP In-Memory Database JDBC Driver, 1.00.48 Build 0372847-1510
|Hadoop 2 and higher||2.3.3|
|5 and higher||18.104.22.1681|
|all||Java SE JDBC/ODBC||Scheduled import is not supported. Before each import, the file has to be selected again.|
|11 and higher||terajdbc4|
Supported in BellaDati 22.214.171.124 and newer.
Usable when a custom connection string is needed or user provides own JDBC driver to the application server.
two mandatory fields:
Connection parameters may vary depending on the selected database vendor. Most common parameters are the following
- host: IP address or domain name
- database: database name
Additional parameters can be specified by clicking on Add link in bottom left part of Connection parameters window. They can include:
- driver: If different drivers are required for various database versions, you can select the right version here (eg. Oracle).
For connection via SSH Tunnel, following parameters have to be added:
- port: this value must be specified
- sshHost: overrides the "host" parameter (optional)
- sshPort: specifies the SSH port, default value is 22 (optional)
If you cannot connect to your database, please verify:
- Host, port, driver and database name (where applicable) are correct. Host should be an IP address or a domain name.
- The database server is reachable from the server running BellaDati. For BellaDati cloud, this means your database must be reachable from the internet.
- The database server's firewall allows incoming requests from the BellaDati server on the database port.
- Database username and password are correct.
There are two options how to query database:
- Database Discovery
- SQL Query Window
Database Discovery is a visual editor for specifying database queries. To obtain data from the your database:
- Click table you want to query. BellaDati includes all columns by default.
- All available columns are selected to be imported. Click on values that you don't want to import. Click on button Update SQL to update sql query according to changes. Use Select all/Unselect all buttons to quickly manipulate with columns.
SQL Query 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.).
Using Stored Procedures
You can also use stored procedures for data import. Stored procedures should have syntax like following:
@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:
- Connection parameters
- SQL statement
- Take me back to data sources
- Import settings
- Scheduling Import
- Connecting over HTTP
- Connecting to FTP
- Connecting to Google Analytics
- Connecting to Facebook
- Connecting to Twitter
- Connecting to Salesforce
- Connecting to Hadoop Hive
- Connecting to Cloudera Impala
- Connecting to Intuit
- Connecting to Existing Data Set