• Kscope15 Recap

    Justin Biard on kscope

    Oracle EPM is at the heart of what I do for a living but there are so many surrounding technologies to consider and KScope is a great place to pickup that knowledge.

    Here are some topics outside of Oracle EPM that caught my attention while visiting the other tracks:

    1. Oracle APEX
    2. Oracle REST Data Services (ORDS)
    3. Oracle Database in the Cloud (both Schema [as a Service] and DBaaS)
    4. Oracle SQL Developer (latest and greatest features)

    Oracle APEX

    This was my first real exposure to APEX and it looks like a very good solution for web application development on top of the Oracle database. The APEX community seems to be thriving which is great. APEX works with Oracle DB and it does not appear to require any additional licenses to use. I have some ideas for how to integrate APEX with Oracle EPM so be on the lookout for more posts about Oracle APEX and Oracle EPM mashups in the future.

    Oracle REST Data Services

    Much of Oracle's move to cloud enabled products is also providing a business driver for web services and related architecture. ORDS is one manifestation of that push to cloud that looks very interesting for small and large business alike. Essentially, use ORDS to expose your Oracle schema / tables to HTTP requests. The requests / responses are handled using a REST API and the results are provided to client applications in JavaScript Object Notation (JSON) format. If you were looking at deploying Oracle Service Bus in your organization but really only need a light-weight REST service on top of your database, this may be a good option for you. This looks like it will make getting an array or single records from your database and into your web or custom application a snap. ORDS is now bundled with Oracle SQL Developer as an option from the menu tree.

    Database (and Schema) as a Service

    If you like the sound of ORDS and want to use Oracle database to make a REST-enabled application then the Oracle Schema as a Service may be a great fit for your application. You are essentially leasing space on a shared Oracle database instance but instead of configuring the database yourself and deploying ORDS, you let Oracle do this for you. NB: The schema is exposed only via web-interfaces at this point. There is no sqlnet client connectivity. Instead, you can manage all of your tables in the schema and the data by using a web interface or the latest and greatest version of SQL Developer with operations against the schema. This is also supported by a web service. Or, if you want a full-fledged Oracle database as a service then you can also get access to this. In this case, an instance of the Oracle database is created including SSH connectivity to Oracle's cloud architecture where you can create and manage your own set of schemas.

    Oracle SQL Developer

    As Oracle EPM professionals we often run into the Oracle database. Although other tools exist, SQL Developer has become my primary choice for working with the Oracle database. This year the team responsible for building SQL Developer provided a lot of great content and updates on the features available in SQL Developer. You can probably imagine that a lot of this had to do with enabling the cloud and also ORDS. Outside of this, there was a lot of great content on tips and tricks with the latest version of SQL Developer and a new command-line utility called sqlcl. If you work with Oracle DB and have not tried SQL Developer, I recommend that you take a look. It is free, has a very active community. Also, the Oracle team that develops the software likes craft beer.

    For Oracle EPM technical content and networking there is really not a better option. Kscope is a great use of your time and money. Throw into that mix all of the other tracks in the Oracle Development space and you can learn a ton in a short amount of time. If you show up a day or two early you can also help the ODTUG community support the local community. This year we went to help kids learn about science and technology. There is always work to be done and this is made possible by volunteers. KScope16 will be in Chicago. I hope to see you there!

    Cheers!