To allow LuciadFusion Studio to connect to a database:
Create a file that specifies the database connection properties, such as the URL and the table name.
.orafile to connect to an Oracle database table
.mssfile to connect to Microsoft SQL Server database table
.pgsfile to connect to a PostgreSQL database table
Add the file to LuciadFusion Studio as you would for any other file, either by setting up the file location as a data root, or by uploading the file.
samples/resources/Data folder for examples of database connection files.
For more information about the connection properties, see the documentation pages for the database type you want to connect to.
If you change a database connection properties file, LuciadFusion Studio needs to re-crawl or re-upload the changed file before
you can test the connection.
Alternatively, you can use the Data Viewer sample, and re-open the connection file after every change. You can select the
Data Viewer sample from the
start.jar application launcher.