Oracle store

04-16-2021 15:06

I'm excited to announce jsreport now supports storing report templates in the Oracle database. This was possible only because of the contribution done by @jorisdebock. Thank you!

You can find the documentation here, but the installation is pretty much standard to other jsreport template stores.

Installation...

npm i @jsreport/jsreport-oracle-store

Configuration...

"store": {
  "provider": "oracle"
},
"extensions": {
  "oracle-store": {
    "user": "system",
    "password": "oracle",
    "connectString": "localhost:1521/xe",
  }
}

The only extra additional step required is to install oracle instant client and add it to the PATH environment variable.

For completeness, this is the table of the currently supported template store providers.

Documentation Technology
jsreport-fs-store file system + Azure Storage + AWS S3
jsreport-mssql-store Microsoft SQL Server
jsreport-postgres-store PostgreSQL
jsreport-mongodb-store MongoDB
jsreport-oracle-store Oracle

What's next? We will soon ship jsreport v3 and include also blob storage implementation to the oracle store. Actually, every sql based store will by default include the blob storage implementation for the most convenient use. And next? Would you like us to add mysql store?