{"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":"2024-11-20T10:50:22","modified_gmt":"2024-11-20T02:50:22","slug":"multiple-systems-or-databases","status":"publish","type":"post","link":"https:\/\/www.finereport.com\/en\/product-functions\/multiple-systems-or-databases.html","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 title=\"reporting tools\" href=\"\/en\/\"><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 title=\"report designer\" href=\"http:\/\/www.finereport.com\/en\/features\/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 class=\"whitespace-pre-wrap break-words\">FineReport supports the following types of data sources:<\/p>\n<ul class=\"-mt-1 [li&gt;&amp;]:mt-2 list-disc space-y-2 pl-8\">\n<li class=\"whitespace-normal break-words\">Relational Databases:\n<ul class=\"-mt-1 [li&gt;&amp;]:mt-2 list-disc space-y-2 pl-8\">\n<li class=\"whitespace-normal break-words\">Traditional RDBMSs including Oracle, SQL Server, MySQL, DB2, Sybase, Access, Derby, PostgreSQL, and Informix<\/li>\n<li class=\"whitespace-normal break-words\">Enterprise solutions like <a href=\"https:\/\/www.fanruan.com\/en\/glossary\/data-integration\/mysap\" target=\"_blank\" rel=\"noopener\"><span style=\"color: #0000ff;\">mySAP<\/span><\/a><\/li>\n<li class=\"whitespace-normal break-words\"><a href=\"https:\/\/www.fanruan.com\/en\/glossary\/data-integration\/mpp-database\" target=\"_blank\" rel=\"noopener\"><span style=\"color: #0000ff;\">MPP databases<\/span><\/a> for large-scale data processing<\/li>\n<li class=\"whitespace-normal break-words\">Supports SQL tables, views, and stored procedures<\/li>\n<\/ul>\n<\/li>\n<li class=\"whitespace-normal break-words\">Non-relational Databases:\n<ul class=\"-mt-1 [li&gt;&amp;]:mt-2 list-disc space-y-2 pl-8\">\n<li class=\"whitespace-normal break-words\">OLAP solutions: Essbase, SSAS<\/li>\n<li class=\"whitespace-normal break-words\">Big Data platforms: Hadoop, Hive<\/li>\n<li class=\"whitespace-normal break-words\">Enterprise systems: SAP HANA, SAP BW<\/li>\n<li class=\"whitespace-normal break-words\">NoSQL databases: MongoDB<\/li>\n<li class=\"whitespace-normal break-words\">In-memory analytics: FineCube<\/li>\n<\/ul>\n<\/li>\n<li class=\"whitespace-normal break-words\">Text Data Sources:\n<ul class=\"-mt-1 [li&gt;&amp;]:mt-2 list-disc space-y-2 pl-8\">\n<li class=\"whitespace-normal break-words\">Excel, TXT, and XML documents<\/li>\n<\/ul>\n<\/li>\n<li class=\"whitespace-normal break-words\">Other Data Sources:\n<ul class=\"-mt-1 [li&gt;&amp;]:mt-2 list-disc space-y-2 pl-8\">\n<li class=\"whitespace-normal break-words\">Server built-in data sources<\/li>\n<li class=\"whitespace-normal break-words\">Report built-in datasets<\/li>\n<li class=\"whitespace-normal break-words\">JSON datasets<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/GrG8M2a-plA?list=PLNsP3hXWcnyoS-L-7MWJoZDxZswQIdVN-\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, I am the reporting girl. Our company has been gradually running ERP, HR, and financial systems within several years. They service different departments independently. One day, my boss told me he wants to see customer, sales, financial and employee data in a uniform portal and wants to make cross data analysis among them. OH,&#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],"yst_prominent_words":[1747,2077,372,416,408,1871,197,1595],"_links":{"self":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3987"}],"collection":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/comments?post=3987"}],"version-history":[{"count":4,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3987\/revisions"}],"predecessor-version":[{"id":19172,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3987\/revisions\/19172"}],"wp:attachment":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/media?parent=3987"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/categories?post=3987"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/tags?post=3987"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=3987"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}