Datawarehouse Architect

BUSINESS INTELLIGENCE CLOUD SERVICE ARCHITECTURE Any users required guidance and discover the right questions by using the analytic and this type of analytic required reach and quality data and the very important is richness in the functionality to solve the hard questions.   Flexibility and functionality to view analytic is given by cloud Oracle BICS. Below is architecture of BICS. Oracle BICS Architecture The Business Intelligence Cloud Service and Data Sync supports the load of on-premises data residing in one or more relational or comma-separated value file sources into the schema provisioned on the Oracle Business Intelligence Cloud Service. PRE-REQUISITES for DATA SYNC: Requirements Before installing, you must have the Java 1.7 or later version of Java Developer Kit (JDK). On an on-going basis, any critical updates specific to this version of Java should always be applied. DATABASE SUPPORT: Business Intelligence Cloud Service Data Sync supports the following datab...

Download mysql-connector-java-5.1.34.bin.jar and com.mysql.jdbc-5.1.5.jar and place it data sync folder. Source connection: If connection fails, paste the data sync path in system properties Go to view->system properties-> paste the path in Data file root directory, And click save. Click test connection Here in MYSQL I have created a table named book Then go to projects, in that click Relational Data and click Data from SQL Give name for the target table and write a select query (e.g.: select * from book) Then click ok Go to target tables/Data sets, in that click table columns, you could see the target table columns. Click run job Go to jobs and click current jobs. Click history in jobs Job successfully completed Go to object browser in BICS, you would see the target table book1 has been loaded successfully.