Demo Databases (FireDAC)
Go Up to Getting Started (FireDAC)
This topic describes how to install the FireDAC demo databases.
Generalities
FireDAC uses the Northwind as a demo database. The SQLite and MS Access demo databases are preinstalled and do not require any additional configuration. For other DBMS, you have to set up the connection and create a database. FireDAC contains SQL scripts, CSV data files, and BAT files. The demo database may be created manually at any time.
Prerequisites
- In order to create database objects, first manually create a database file, to install the objects into it (for InterBase and FireBird, this requirement to have a database file is not mandatory).
- You should also have an existing user account.
- SQLite - the installer installs a ready-to-use database file at
C:\Users\Public\Documents\Embarcadero\Studio\23.0\Samples\Data\fddemo.sdb. - Access database - the installer installs a ready-to-use database file at
C:\Users\Public\Documents\Embarcadero\Studio\23.0\Samples\Data\fddemo.mdb. - SQL Server 2000 - the Northwind DB installation may be optional. Since it is part of the SQL Server 2000 distribution, it may be downloaded separately or it may be already installed.
Build Demo DB
To build a demo database, perform the following steps:
- Run the FDExplorer
- Create a connection definition for a required DBMS. The connection definition must have a predefined name, depending on the DBMS:
| DBMS | Sample connection definition | Connection definition name |
|---|---|---|
| Advantage Database | [ADS_Demo]
DriverID=ADS ServerTypes=2 Database=\\DA\ADS_DB\ADDEMO.ADD User_Name=adssys |
ADS_Demo |
| IBM DB2 Server | [DB2_Demo]
DriverID=DB2 Alias=addemo User_Name=db2admin |
DB2_Demo |
| Firebird | [FB_Demo]
DriverID=FB Database=E:\Firebird\ADDEMO.FDB User_Name=sysdba |
FB_Demo |
| Informix | [Infx_Demo]
DriverID=Infx Server=ol_informix1170 Database=sysuser User_Name=informix |
Infx_Demo |
| InterBase | [IB_Demo]
DriverID=IB Database=E:\Interbase\ADDEMO.GDB User_Name=sysdba |
IB_Demo |
| Microsoft Access Database | [Access_Demo]
DriverID=MSAcc Database=(RAD Studio Demos)\Data\fddemo.mdb |
Access_Demo |
| Microsoft SQL Server | [MSSQL_Demo]
DriverID=MSSQL Server=127.0.0.1 Database=Northwind User_Name=sa |
MSSQL_Demo |
| MySQL Server | [MySQL_Demo]
DriverID=MySQL Server=127.0.0.1 Database=addemo User_Name=root |
MySQL_Demo |
| Oracle Server | [Oracle_Demo]
DriverID=Ora Database=ORA_920_APP User_Name=ADDemo |
Oracle_Demo |
| PostgreSQL | [PG_Demo]
DriverID=PG Server=127.0.0.1 Database=addemo User_Name=ad |
PG_Demo |
| SQLite database | [SQLite_Demo]
DriverID=SQLite Database=(RAD Studio Demos)\Data\fddemo.sdb |
SQLite_Demo |
| Sybase SQL Anywhere | [ASA_Demo]
DriverID=ASA Server=addemo_asa11 Database=addemo_asa11 User_Name=dba |
ASA_Demo |
| Teradata Database | [TData_Demo]
DriverID=TData Server=192.168.43.140 User_Name=dbc Password=dbc |
TData_Demo |
- Go to the
C:\Users\Public\Documents\Embarcadero\Studio\23.0\Samples\Object Pascal\Database\FireDAC\Binfolder. - SQL Server - to disable the Northwind DB installation, open
createMSSQL.batand replaceTruewithFalse. For the SQL Server 2000, replace MSSQL with MSSQL2000. - Run create<your DBMS>.bat.