Database connectors
With Biwee, you can connect to different databases. Here is a description of the configuration of the different connectors.
Dernière mise à jour
Cet article vous a-t-il été utile ?
With Biwee, you can connect to different databases. Here is a description of the configuration of the different connectors.
Dernière mise à jour
Cet article vous a-t-il été utile ?
To connect to SQL Server, here is the information you need to fill in.
Connection name: Name that will be saved in your Biwee resources
Server: Adress or name of the database server
Authentication:
Select SQL Server Authentification or Windows Authentification
Username
Password
Database:
Select the database name from the list box.
To connect t o your Access database, here is the information you need to fill in:
Connection name: Name that will be saved in your Biwee resources.
Database: You can browse in your Windows explorer, select your Acess database or you can directly enter the location in the corresponding field.
Authentication:
Username
Password
To connect to your Oracle SQL database, here is the information you need to fill in:
Connection name: Name that will be saved in your Biwee resources.
Server: Address or name of the database server.
Port
Authentication:
Username
Password
Database: Enter the name of your database.
To connect to your MySQL database, here is the information you need to fill in:
Connection name: Name that will be saved in your Biwee resources.
Server: Address or name of the database server.
Port: Default value -> 3306
Authentication:
Username
Password
SSL: Secure information exchange. You can choose from: Prefer, Require or Disabled.
Database: Select the name of the database in the list box.
To connect to your mongoDB database, here is the information you need to fill in:
Connection name: Name that will be saved in your Biwee resources.
Connection string
Password
Database: Enter the name of your database.
To connect to your Hyperfil SQL database, here is the information you need to fill in:
Connection name: Name that will be saved in your Biwee resources.
Server: Address or name of the database server.
Port
Authentication:
Username
Password
Database: Select the database name from the list box.
Enter the location of the database or select the database via Windows Explorer.
To connect to your Firebird SQL database, here is the information you need to fill in:
Connection name: Name that will be saved in your Biwee resources.
Server: Address or name of the database server.
Port: Default value -> 3050
Authentication:
Username
Password
Database: Enter the location of your database.
To connect to your PostgreSQL database, here is the information you need to fill in:
Connection name: Name that will be saved in your Biwee resources.
Server: Address or name of the database server.
Port
Authentication:
Username
Password
SSL: Secure information exchange. You can choose from: Prefer, Require or Disabled.
Database: Enter the location of your database.
To connect to your SQLite database, here is the information you need to fill in:
Connection name: Name that will be saved in your Biwee resources.
Database: You can browse in your Windows explorer, and select your SQLite database file.
Authentication:
Username
Password
To connect to your Azure Table database, here is the information you need to fill in:
Connection name: Name that will be saved in your Biwee resources.
Account name
Table name
Key: access key to connect to your Azure Table.
Lines limit: The maximum number of lines in your query.
To connect to your OLE DB database, here is the information you need to fill in:
Connection name: Name that will be saved in your Biwee resources.
Connection string
The connection string is in the following form:
Provider='Your provider'; Data Source='Location of your database';User ID='Your login';Password='Your password'; Example: Provider=Microsoft.Jet.OLEDB.4.0; Data Source=d:\Northwind.mdb;User ID=Admin;Password=;
To connect to your ODBC database, here is the information to fill in:
Connection name: Name that will be saved in your Biwee resources.
Connectio string
To connect to your IBM DB2 database, here is the information you need to fill in:
Connection name: Name that will be saved in your Biwee resources.
Server: Adress or name of the database server.
Authentication:
Username
Password
Database: Enter the name of your database.
To connect to your Amazon Redshift database, here is the information you need to fill in:
Connection name: Name that will be saved in your Biwee resources.
Server: Address or name of the database server.
Port
Authentication
Username
Password
SSL: Secure information exchange. You can choose from: Prefer, Require or Disabled.
Database: Enter the name of your database.
SSL allows to protect data by encrypting them during their transfer between the database and Biwee. We offer 3 modes in Biwee:
DISABLED: SSL is not used and the connection is not encrypted.
PREFERRED: An encrypted connection is established if the database server supports it, otherwise a non-encrypted connection will be used.
REQUIRED: An encrypted connection is established. If the database server does not support it, the connection fails.
It is possible to use aliases to temporarily rename a column or table in a query.
Example: A column that is normally called c_iso_3166 can be renamed "country_code" (cf. the ISO 3166 code corresponds to the country code), which is easier to understand in the rest of the code by a developer.
To import your alias, click on the "Import alias" button, select your alias as a .txt file in the Windows explorer and validate.
The format of the expected file is the following :
A text file with the extension .txt, with 2 columns separated by a tab
A header line with the title of the each of the 2 columns : column and alias for example
One line for each column to rename containing its original name, and the alias, separated by a tab
For most of the connectors it is possible to directly modify the connection string.
It is of the following form:
Data Source='Address or name of your server' ;Initial Catalog='Name of your database' ;Integrated Security='True or False' ;User ID='Your login';Password='Your password'.
Possibility to import an .
Possibility to import an .
Possibility to import an .
Possibility to import an .
Possibility to import an .
Possibility to import an .
Possibility to import an .
Possibility to import an
Possibility to import an .
Possibility to import an .
Possibility to import an .
