Apache Derby connection
To access your data in Apache Derby, create a connection asset for it.
Apache Derby is a relational database management system developed by the Apache Software Foundation.
Create a connection to Apache Derby
To create the connection asset, you need these connection details:
- Database name
- Hostname or IP address
- Port number
- Username and password
- SSL certificate (if required by the database server)
For Credentials and Certificates, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.
Choose the method for creating a connection based on where you are in the platform
- In a project
- Click Assets > New asset > Prepare data > Connect to a data source. See Adding a connection to a project.
- In a catalog
- Click Add to catalog > Connection. See Adding a connection asset to a catalog.
- In a deployment space
- Click Import assets > Data access > Connection. See Adding data assets to a deployment space.
- In the Platform assets catalog
- Click New connection. See Adding platform connections.
Next step: Add data assets from the connection
Federal Information Processing Standards (FIPS) compliance
This connection can be used on a FIPS-enabled cluster (FIPS tolerant); however, it is not FIPS-compliant.
Apache Derby setup
Running SQL statements
To ensure that your SQL statements run correctly, refer to the Apache Derby documentation for the correct syntax.
Learn more
Parent topic: Supported connections