{"id":3031,"date":"2020-11-21T14:48:52","date_gmt":"2020-11-21T22:48:52","guid":{"rendered":"https:\/\/www.omtiblog.com\/reporterbase101\/?p=3031"},"modified":"2026-04-14T12:54:44","modified_gmt":"2026-04-14T19:54:44","slug":"data-reader","status":"publish","type":"post","link":"https:\/\/www.omtiblog.com\/reporterbase101\/plug-ins\/data-reader\/","title":{"rendered":"Data Reader"},"content":{"rendered":"<h6>Plug-in #4<\/h6>\n<h5>Create custom reports with your RB9 data<\/h5>\n<p>If you are on RB9, you cannot create custom reports in other applications using your RB9 data without the Data Reader plug-in. This is due to security issues with directly connecting to RB9 databases in the cloud. Data Reader solves that problem with a dedicated connection to your RB9 database in the cloud so you can use your RB9 information in your own reports or other applications.<\/p>\n<h2>DIY reports in 3rd-party applications<\/h2>\n<p>If you want to view your RB9 data in a way that is not already available in RB9 \u2014 such as a marketing or financial report that is not part of RB9 \u2014 add Data Reader to give yourself remote access to your data.<\/p>\n<p>With Data Reader, you log into your RB9 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 RB9 data.<\/p>\n<p>You do not have to install anything on your end to use Data\u00a0Reader. And like all RB plug-ins, you subscribe to it on a monthly\u00a0basis and can cancel it at any time.<\/p>\n<h3>Use your RB9 data with:<\/h3>\n<ul>\n<li>Microsoft<\/li>\n<li>Access<\/li>\n<li>Crystal<\/li>\n<li>Reports<\/li>\n<li>IBM Cognos<\/li>\n<li>Analytics<\/li>\n<li>Qlik Sense<\/li>\n<li>Sisense<\/li>\n<li>Tableau<\/li>\n<li>and more<\/li>\n<\/ul>\n<h2>Secure access<\/h2>\n<p>Data Reader is a secure way to access your RB9 database from outside RB9 because:<\/p>\n<ol>\n<li>Data Reader is read-only data, meaning you cannot write to your RB9 database from your outside applications or create any objects in SQL Server.<\/li>\n<li>Only workstations\/IP addresses (depending on which Data Reader\u00a0version you have) that you register with OMTI can access your\u00a0database.<\/li>\n<\/ol>\n<h2>Plug-in options<\/h2>\n<p>Data Reader comes in two sizes:<\/p>\n<h3>Per Workstation<\/h3>\n<p>Version for creating custom reports\u00a0on individual workstations.\u00a0Good for companies who write\u00a0reports on up to 3 workstations.\u00a0Or for companies with remote offices\/workers who need to write reports.<\/p>\n<p>Works for only the named workstation(\u00a0s) you register with OMTI.\u00a0A license cannot be shared, so\u00a0if you want to write reports on\u00a0a desktop computer and your\u00a0laptop, you will need 2 licenses.<\/p>\n<h3>Per IP<\/h3>\n<p>Version for companies that\u00a0need to have four or more\u00a0workstations on the same IP address access their\u00a0database outside RB9.<\/p>\n<p>Allows all workstations in an office to access your RB9 data. The public IP you specify can access your database. If you want to create custom reports on 4 or more workstations In your office, Data Reader \u2013 Per IP will be cheaper.<\/p>\n<p><em>NOTE: Sensitive information, such as\u00a0Tax ID and Social Security numbers,\u00a0are encrypted and will not be usable\u00a0data outside RB9.<\/em><\/p>\n<h2>Which version is right for you?<\/h2>\n<p>Most companies will probably\u00a0need Data Reader on only one\u00a0workstation to generate reports\u00a0that can then be emailed to\u00a0everyone who needs to read the\u00a0report.<\/p>\n<p>If you do require multiple workstations to access your RB9 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.<\/p>\n<h2>New workstation?<\/h2>\n<p>If you ever want to switch\u00a0your Data Reader registration\u00a0to a different workstation or\u00a0public IP, ask us and we can\u00a0process your request within\u00a0one business day.<\/p>\n<p><em>NOTE: Data Reader is not available with RB9 Lite.<\/em><\/p>\n<p><strong>TL;DR: Use the Data Reader plug-in to create custom reports with RB9 data in other applications.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Add the Data Reader plug-in to your RB9 office and free your data to use outside RB9 <a href=\"https:\/\/www.omtiblog.com\/reporterbase101\/plug-ins\/data-reader\/\">&hellip;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[230],"tags":[232,231],"class_list":["post-3031","post","type-post","status-publish","format-standard","hentry","category-plug-ins","tag-data-reader","tag-plug-in"],"_links":{"self":[{"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/posts\/3031","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/comments?post=3031"}],"version-history":[{"count":0,"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/posts\/3031\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/media?parent=3031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/categories?post=3031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/tags?post=3031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}