Monday 3 July 2017

Universal Data Access – Defining the Oracle Database Source System and Source Adapters

In this blog, I would be talking about defining Oracle database source system and source adapters for enabling Universal Data access. Now, the data we plan to load into an application using FDMEE is present in a table called FINRPT_STAGING. The contents of the table is shown in the below snapshot.

The table definition of the FINRPT_STAGING table is as shown in the below snapshot.

The Setup tab of FDMEE is as shown in the below snapshot.

The next step is to define the Source System for the Oracle table. This is as shown in the below snapshot.

The next step is to define the Source Adapter for the Oracle database.

A source adapter is an integration framework in Oracle Hyperion Financial Data Quality Management, Enterprise Edition that enables you to extract data from the source system in a flexible and customizable manner.
The Source Adapter tab is as shown in the below snapshot.

I click on the add button to add a new Source adapter. The details of the new source adapter is as shown in the below snapshot.

  • The Adapter key is named as “FINRPT”
  • Given a name to the adapter called “FINRPT_STAGE_ORCL_ADPT”
  • The Source system reflects the Oracle data source to which I want to connect.
  • Table name is pointing to FINRPT_STAGING which reflects the Oracle table that I want to connect to.
After hitting the save button, the new source adapter is added as shown in the below snapshot.

Click on the “Import Table Definition” to see if the configuration has been completed successfully. If it is working as expected, you should get a screenshot as shown in the below snapshot. 

Click on OK button to import the table definition.
The snapshot after the table definition has been imported successfully is as shown below. 


The table metadata comes through in the FDMEE landing page as shown in the following couple of snapshots. 

Once the metadata has come through, click on the “Generate Template Package” button. This is shown in the below snapshot. 
The below snapshot shows the Template Package being generated successfully. 
An interesting aspect of the Source Adapter is that I can create and define filters to filter the records which come from the source system. Let us assume a case that we make use of FDMEE to load data for multiple entities. All these entities update the same target table. However, all of these Entities do not update the data simultaneously. So I can have a case where my Entity E1 has updated all of the data in the source table, but my Entity E2 has only updated half the records. The remaining half will be updated in a couple of days. Thus, I do not want to load E2 entities in a load now and I will do the load of E1 today. This can be accomplished by parameters in the Source Adapter. Me defining the Source Adapter parameters is as shown in the below snapshot. 

In the next blog, we will create an Import Format and try to import data from a relational table into FDMEE using Universal Data Adapter.

Link to previous blogs:

Installing Oracle Data Integrator for enabling Universal Data Access in FDMEE  - http://exploitsinhyperion.blogspot.in/2017/04/installing-oracle-data-integrator-for.html

Connecting to FDMEE Work Repository using Oracle Data Integrator  - http://exploitsinhyperion.blogspot.in/2017/04/connecting-to-fdmee-work-repository.html

Applying OPATCH for enabling Universal Data Access in FDMEE - http://exploitsinhyperion.blogspot.in/2017/05/applying-opatch-for-enabling-universal.html

Defining the Physical and Logical schema for Oracle data source  - http://exploitsinhyperion.blogspot.in/2017/06/universal-data-access-defining-physical.html

Importing Adapters and Universal Data Access Models - http://exploitsinhyperion.blogspot.in/2017/06/fdmee-universal-data-access-importing.html

40 comments:

  1. Being new to the blogging world I feel like there is still so much to learn. Your tips helped to clarify a few things for me on Oracle Hyperion Planning

    ReplyDelete
  2. This site has lots of advantage.I found many interesting things from this site. It helps me in many ways.
    c language training

    ReplyDelete
  3. Thanks for giving such a nice and useful information. I have learned so much from your blog. Thank you!!
    App V Online Training

    ReplyDelete
  4. QuickBooks Enterprise Support contact number is assisted by an organization this is certainly totally dependable. It is a favorite proven fact that QuickBooks Enterprise Tech Support Number has had about plenty of improvement in the area of accounting. In the long run quantity of users and selection of companie

    ReplyDelete
  5. QuickBooks Support Phone Number advisors are certified Pro-advisors’ and it has forte in furnishing any kind of technical issues for QuickBooks. These are typically expert and certified technicians of their domains like QuickBooks accounting,QuickBooks Payroll, Point of Sales, QuickBooks Merchant Services and Inventory issues to provide 24/7 service to your esteemed customers.

    ReplyDelete
  6. As QuickBooks Payroll Support Number we utilize the responsibility of resolving all the problems that hinder the performance associated with the exuberant software. There clearly was sometimes a number of errors that could bother your projects flow, nothing should be taken as burden with that said because the support team of Quickbooks Payroll customer service resolves every issue in minimal some time commendable expertise.

    ReplyDelete
  7. There could be occasions as soon as you might face some form of delay in reaching QuickBooks Customer Service Phone Number, let’s say during the time of filing taxes because there is lots of hush-hush then.

    ReplyDelete
  8. Support for QuickBooks Enterprise Help Phone number will be the first point of contact to report the matter where you get all of your worries taken care off and assured solutions right away offers you complete peace of mind.

    ReplyDelete
  9. Getting instant and effective help for almost any case of concern is really what the user’s desire for. With QuickBooks, it is possible to relax knowing about having the most desirable and efficacious help on every issue that you could encounter yourself with. You just need to avail the help through the technical experts by dialing the QuickBooks Support Number .

    ReplyDelete
  10. Being a regular business person, working on professional accounting software, like QuickBooks, just isn't always easy. Thus, users may have to face a quantity of issues and error messages when using the software; once you feel something went wrong together with your accounting software and cannot discover a way out, you can get technical support from QuickBooks Support Number , day time and night to fix any issues linked to QuickBooks.

    ReplyDelete
  11. QuickBooks Support Number Services provide approaches to all your valuable QuickBooks problem and in addition assists in identifying the errors with QuickBooks data files and diagnose them thoroughly before resolving these issues.

    ReplyDelete
  12. The world-wide-web is stuffed with faux numbers WHO decision themselves the QuickBooks Support Provider. you’ll value more highly to dial their variety however that would be terribly risky. you’ll lose your QuickBooks Company file or the code itself. dig recommends dialing solely the authentic QuickBooks Support.

    ReplyDelete

  13. Have you been encountering issues in running of QuickBooks Technical Support Number Premier? We urge that you not ever suffer from losses due to longer downtime of your respective QB Premier.

    ReplyDelete
  14. Today, payroll running is currently complex. You may need advanced software. There must be a premier mix solution. QuickBooks Payroll Service Number often helps.

    ReplyDelete
  15. Let’s speak about our QuickBooks Online Enterprise Contact Number that'll be quite exciting for your needs all. The advanced QuickBooks Desktop App for QuickBooks Support can now work as an ERP system beneficial for medium scale businesses. QuickBooks Desktop Enterprise is certainly not alike to pro, premier & online versions. Capacity and capability could be the cause of this.

    ReplyDelete
  16. checks or client reports. We plan to give you the immediate support by our well- masterly technicians. A team of Intuit QuickBook Support dedicated professionals is invariably accessible in your case so as to arranged all of your problems in an attempt that you’ll be able to perform your work whilst not hampering the productivity.

    ReplyDelete
  17. QuickBooks Payroll Customer Support Number is available and helpful to many business people, accountants, CA, CPA to calculate taxes and pay employees. Several types of issues and errors arise the need to contact the Intuit Payroll support team using QuickBooks Payroll telephone number.

    ReplyDelete

  18. QuickBooks Payroll Support Phone Number Customer Service Number helps you to definitely resolve your entire technical and functional issues while looking after this well known extensive, premium and end-to-end business accounting and payroll management software.

    ReplyDelete
  19. With exceptional features, QuickBook helps all of the forms of businesses with generating accounting reports, entries for almost any sale, transactions pertaining to banking, etc., with a lot of ease. And along QuickBooks Tech Support Phone Number, it is less difficult to handle most of the tools of QuickBooks in a hassle-free manner. Below is a summary of several QuickBooks errors that one may meet with if you are using it. Have a glimpse at it quickly.

    ReplyDelete

  20. The primary functionality of QuickBooks Tech Support Number is determined by company file. In line with the experts, if you'd like solve the problem, then you'll definitely definitely definitely need certainly to accept it first.

    ReplyDelete
  21. “Just dial our Phone Number for QuickBooks Payroll Support to inquire of about for Quickbooks Payroll customer care to get rid of payroll issues. We take advantage of startups to small-scale, medium-sized to multinational companies.”

    ReplyDelete

  22. If QuickBooks Enterprise Tech Support Phone Number are starting your own business, what are the things that you will look out for? One of the appropriate approaches is to have all the options in front of you and then choose from the best one.

    ReplyDelete
  23. Our customer service executives at QuickBook Tech Support Phone Number do not hesitate from putting extra efforts to give you relief from the troubles caused by QB Payroll errors.

    ReplyDelete
  24. The guide might have helped you understand QuickBooks file corruption and methods to resolve it accordingly. If you would like gain more knowledge on file corruption or any other accounting issues, then we welcome you at our QuickBooks Support Number

    ReplyDelete
  25. Our team offers a whole financial solution for your account. So just contact us on our QuickBooks Tech Support Number and sharing your all kind of accounting worries with us, we are going to definitely help you with your best QuickBooks updates in addition to solve your all QuickBooks errors.

    ReplyDelete
  26. And check out associated with factors why QuickBooks is great accounting software for your needs. All of us offers a total financial solution for your account. So just contact us on our QuickBooks Tech Support Phone Number and sharing your all form of accounting worries with us,

    ReplyDelete
  27. The accounting the main many companies varies based on this package. You will find so many fields it covers like creating invoices, managing taxes, managing payroll etc. However exceptions are typical over, sometimes it creates the negative aspects and user wants Intuit QuickBooks Support

    ReplyDelete
  28. Hi, I really loved reading this article. By this article i have learnt many things about Hyperion Planning topic, please keep me updating if there is any update

    Hyperion Planning Online Training
    Hyperion Planning Training
    Hyperion Planning Training in Hyderabad

    ReplyDelete
  29. QuickBooks Payroll Support Phone Number accords assistance to the QuickBooks users’ worldwide. The support team could be reached through various modes such as: phone support, email support, live chat, FAQ, QuickBooks community etc. Solving the Quickbooks related problems and issue Remotely .

    ReplyDelete
  30. QuickBooks users in many cases are found in situations where they have to face many of the performance plus some other errors as a result of various causes inside their computer system. If you want any help for QuickBooks errors from customer care to get the solution to these errors and problems, it is an easy task to experience of QuickBooks Phone Number and find instant assistance with the guidance of your technical experts.

    ReplyDelete
  31. In case, when you can get stuck with any HP problems, go ahead and connect with the HP Printer Support Number experts who are always readily available for you to definitely give you an instantaneous help.

    ReplyDelete
  32. QuickBooks Enterprise Support contact number team makes it possible to deal with most of the issues of QuickBooks Enterprise Support Phone Number. Now let’s have a look regarding the industry versions therefore it has furnished us with. You will discover six forms of industry versions that QB Enterprise offers.

    ReplyDelete
  33. QuickBooks Payroll Support Phone Number is one such software which includes instilled the best feeling of using your money plus it’s management when you look at the best possible manner.

    ReplyDelete
  34. In conclusion, don’t hesitate to call us on our QuickBooks Online Help Number. We are surely here for you. In summary, any error, any issue, any bug or anything else linked to QuickBooks related problem, just call our QuickBooks Support Phone Number. Surely, call our QuickBooks Support phone Number.

    ReplyDelete
  35. you’ll additionally visit QuickBooks Tech Support Phone Number web site to induce to understand additional concerning our code and its upgrades. you’ll scan in-depth articles concerning most of the errors and also how you can resolve them. Rectifying errors desires in-depth information regarding the device as well as its intricacies.

    ReplyDelete
  36. Payroll management is actually an essential part these days. Every organization has its own employees. Employers want to manage their pay. The yearly medical benefit is vital. The employer needs to allocate. But, accomplishing this manually will require enough time. Aim for QuickBooks Payroll Support Number. This can be an excellent software. You can actually manage your finances here.

    ReplyDelete
  37. With exceptional features, QuickBooks Tech Support Number helps most of the kinds of businesses with generating accounting reports, entries for every single sale, transactions pertaining to banking, etc., with a lot of ease. And along side support for QuickBooks, it really is much simpler to undertake all of the tools of QuickBooks in a hassle-free manner. Below is a listing of several QuickBooks errors that one may meet with while you are deploying it. Have a glimpse at it quickly.

    ReplyDelete
  38. QuickBooks Payroll Support Phone Number facilitate for All quite Technical problems You can use QuickBooks to come up with any number of reports you wish, keeping entries for several sales, banking transactions and a lot of additional.

    ReplyDelete
  39. In case you are the client of Quickbooks and face errors like quickbooks won't open that has different various reasons like as your organization record name is extremely long or shows Quickbooks freez that can be resolved with Quickbooks tool hub.

    ReplyDelete