One of the features of Dodeca is read-write functionality to SQL databases. We often get questions as to how to write data back to a relational database, so I thought I would post a quick blog entry for our customers to reference.
This example will use a simple table structure in SQL Server though the concepts are the same when using Oracle, DB2, and most other relational databases. The example will use a simple Dodeca connection to a JDBC database. Here is the Dodeca SQL Connection object used for the connection.
I am more often then not using spring boot applications on IBM Bluemix and most of what I need is packaged with the application from JPA or JDBC, drivers, Rest etc. Of course with IBM Bluemix we can specify which build pack we wish to use but by default for java applications LIberty is used.
When a stand-alone application is deployed, a default Liberty configuration is provided for the application. The default configuration enables the following Liberty features:
I thought I would go through the some of the other REST resources which are only currently available in PBCS and these being around Lifecycle management.
Not all BI tools have the semantic layer. For example, Oracle Discoverer seems not having a strong semantic layer. This page summarizes what OBIEE semantic layer can do for you… BI Platform Semantic Layer I think that if these features can be accomplished in other ways and can be proven that they are not necessary, […]
DOAG Conference 2015 in Nürnberg is getting closer. This is a great opportunity to hear about what is announced at Oracle Open World 2015, mingle with peers and enjoy this years’ invited speaker Gunter Dueck. He published an essay about volkswagening (german only) that is worth reading. Reminds a bit about the graphic card producers that optimized their […]
As described in the A-Team article A Universal Cloud Applications Adapter for ODI, it is technically possible to integrate Cloud Applications with ODI.
Cloud Applications Drivers and Adapters
In order to guide you on how ODI can help you to integrate your Cloud Applications, we have compiled the list of SaaS applications and PaaS services that Oracle Data Integrator can connect to as of today.
These are different concepts. Data Lake – Collect data from various sources in a central place. The data are stored in the original form. Big data technologies are used and thus typical data storage is Hadoop HDFS. Data Warehouse – “Traditional” way of collecting data from various sources for reporting. The data are consolidated and […]
Had I been working in Operations and on-call at an organisation using Java Cloud Service then it appeared I may well have been rudely woken up last night! At around 2am in the UK this email innocently dropped into my mail box:
DMZ is a technology that allows you to configure your network to be accessible outside firewall. Some of users may want to access some of corporate reports from mobile or from their personal computers. While VPN and Citrix may be useful for these cases, DMZ can provide another option. A good article – OBIEE Security […]