Create custom reports with your RB data
Because of security issues with directly connecting to RB databases in the cloud, you cannot create your own custom reports in RB9 using your RB data. The Data Reader plug-in solves that problem with a dedicated connection to your RB database in the cloud so you can use your information in your own reports or other applications.
DIY reports in 3rd-party applications
If you want to view your RB data in a way that is not already available in RB9, such as a marketing or financial report that is not part of RB9, add Data Reader to give yourself remote access to your data.
With Data Reader, you log into your RB database in the cloud from a third-party application, such as Crystal Reports or Microsoft Access, to run reports or perform other functions with your RB data.
You do not have to install anything on your end to use Data Reader. And like all RB plug-ins, you subscribe to it on a monthly basis and can cancel it at any time.
(Data Reader is not available for RB Lite.)
Plug-in options
Data Reader comes in two sizes
Per Workstation
For creating custom reports on individual workstations. Good for companies who will write reports on up to 3 workstations from one IP address. Or for companies with remote offices/workers who need to write reports.
Per IP
For companies that need to have 4 or more workstations using one IP address access their database outside RB9.
Requirements for ordering
Depending on which version you want, you must have two things ready before ordering RB9’s Data Reader:
- Workstation name (Per Workstation account) or public IP address (Per IP account)
- Password for SQL Account:
- Must be 8 or more characters and numbers.
- Must contain one or more alphabet characters, numbers, and special characters.
Secure access
Data Reader is a secure way to access your RB database from outside RB9 because:
- Data Reader is read-only data, meaning you cannot write to your RB database from your outside applications or create any objects in SQL Server.
- Only workstations/IP addresses (depending on which Data Reader version you have) that you register with OMTI can access your database.
If you ever want to switch your Data Reader registration to a different workstation or public IP, ask us and we can process your request within one business day.
NOTE: Sensitive information, such as Tax ID and Social Security numbers, are encrypted and will not be usable data outside RB9.
Price & limitations
| Plug-in Name | Price | Limitation |
|---|---|---|
| Data Reader – Per WorkStation |
$60/mo | Named workstations can access your database. |
| Data Reader – Per IP |
$200/mo | Named public IP can access your database. |
Data Reader – Per Workstation
Works for only the named workstation(s) you register with OMTI. A license cannot be shared, so if you want to write reports on your desktop computer and your laptop, you will need two licenses.
Data Reader – Per IP
Allows all workstations in an office to access your RB data. If you want to create custom reports on four or more workstations, Data Reader – Per IP will be cheaper.
Which version is right for you?
Most companies will probably need Data Reader on only one workstation to generate reports that can then be emailed to everyone who needs to read the report.
If you do require multiple workstations to access your RB data through Data Reader, there are no bandwidth limitations per any plug-in, so there will be no performance issues in relation to how many concurrent connections you make.
For more details, download the Data Reader fact sheet 
or contact OMTI Sales.