{"id":3987,"date":"2016-08-29T16:23:38","date_gmt":"2016-08-29T08:23:38","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3987"},"modified":"2019-10-14T16:18:16","modified_gmt":"2019-10-14T08:18:16","slug":"multiple-systems-or-databases","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2016\/08\/29\/multiple-systems-or-databases\/","title":{"rendered":"Is data dispersed in multiple systems or databases and difficult to utilize?"},"content":{"rendered":"<p>Hi, I am the reporting girl.<br \/>\nOur company has been gradually running ERP, HR, and financial systems within several years. They service different departments independently.<br \/>\nOne day, my boss told me he wants to see customer, sales, financial and employee data in a uniform portal and wants to make cross <a title=\"data analysis\" href=\"\/en\/\"><span style=\"color:blue;\">data analysis<\/span><\/a> among them.<\/p>\n<p>OH, my god!<br \/>\nThose data dependently stored in 3 different databases of 3 systems.<\/p>\n<p><img class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201682901.png\" alt=\"\" \/><\/p>\n<p>When I was just in trouble, a <a href=\"\/en\/\" title=\"reporting tools\"><span style=\"color:blue;\">reporting tool<\/span><\/a> really help me a lot!<\/p>\n<p>Fetch the data I need from Mysql, Oracle, and SQL SERVER. Then design the report format and do calculations in the <a href=\"http:\/\/www.finereport.com\/en\/features\/report-designer\" title=\"report designer\"><span style=\"color:blue;\">report designer<\/span><\/a>. Finally, view it via a browser or a reporting system!<\/p>\n<p><img class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201682902.png\" alt=\"\" \/><\/p>\n<p>What&#8217; s more, the data in the report will change with changes in the 3 systems. No duplicate work is needed!<br \/>\nThis is the famous muti-data resources function of reporting tool.<br \/>\n<strong>Two points are important to note here:<\/strong><br \/>\nFirst, data from the same or different databases can be integrated into one report.<\/p>\n<p><img class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201682903.png\" alt=\"\" \/><\/p>\n<p>Second, the tool can support as many data sources as possible.<\/p>\n<p>FineReport supports the following types of data sources:<br \/>\n* Relational Database\uff1a Include such mainstream relational databases as Oracle, SqlServer, Mysql, DB2, Sybase, Access, Derby, Postgre, Informix; Support SQL data sheets or views, or stored procedures.<br \/>\n* Non-relational Database\uff1aEssbase, Ssas, Sap, Hadoop, FineCube, Saphana, Sapbw, MongoDB, Hive.<br \/>\n* Text Data Sources: Data in Excel, Txt, XML documents.<br \/>\n* Other Data Sources: Built-in data source in server, built-in data set in the report, and JSON data set.<\/p>\n<p><iframe loading=\"lazy\" width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/GrG8M2a-plA?list=PLNsP3hXWcnyoS-L-7MWJoZDxZswQIdVN-\" frameborder=\"0\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, I am the reporting girl. Our company has been gradu&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[111],"tags":[117],"_links":{"self":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3987"}],"collection":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/comments?post=3987"}],"version-history":[{"count":4,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3987\/revisions"}],"predecessor-version":[{"id":8294,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3987\/revisions\/8294"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=3987"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=3987"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=3987"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}