Posts Tagged ‘Sybase’

Working With Multiple LOCAL_XE Databases In Siebel IP2016

In Siebel IP2016, the Sybase database was replaced with Oracle’s own XE database. The switch has presented some advantages and some drawbacks. One of the advantages is that you can have multiple instances. In my case, I have one instance for each IP2016 project that I am working on. This is the blog that I […]

How To Install Siebel Tools In A Working Environment

I have seen quite a few blog posts on how to setup Siebel Innovation Pack 2016 (IP2016) in a test bed environment, but very little chatter on how to actually install IP2016 Siebel Tools (Tools) and use it in a real development project. Hopefully, this will help some of you out there. Feel free to […]

Oracle BICS for Salesforce, RightNow, Amazon, IBM & Big Data

Earlier this week, Oracle upgraded its BI Cloud Service platform as well as DataSync (now version 2.2) for cloud integrations. With those 2 upgrades come great benefits if you have any of the following and looking to do consolidated business analytics from multiple source systems and allow for cross-functional insights: Salesforce: There is no need […]

PowerDesigner Tips – Column Ordering

In our standards XEM file (extended model definition), I’ve added column ordering functionality by categorizing each column and then ordering the categories. Column groups are defined in a BaseColumn template.  We have:   PRIM,0,%Primary% ROWMETA,3,%extIsRowDateMeta% META,4,%extIsMetaColumn% AKNONMETA,1,%AllKeys% BASE,2,TRUE  

PowerDesigner Table Object Hierarchy

PowerDesigner – Standards in Action

I love PowerDesigner.  It’s the Cadillac (Mercedes, BMW, etc.) of the modeling tools.  I love that I can do conceptual, logical, and physical data modeling.  I can do business process modeling with direct linkage to my data models.  And I can model mappings between everything for both data flow relationships (ETL mappings) and design flow […]