Infrastructure at your Service

Category Archives: Business Intelligence

Oracle Team

Change Data Capture from Oracle with StreamSets Data Collector

By | Business Intelligence, Database Administration & Monitoring, Oracle | 4 Comments

By Franck Pachot . With this trend of CQRS architectures where the transactions are streamed to a bunch of heterogenous eventually consistent polyglot-persistence microservices, logical replication and Change Data Capture becomes an important component, already at the architecture design phase. This is good for existing products vendors such as Oracle GoldenGate (which must be licensed even to use only the CDC part in the Oracle Database as Streams is going to be desupported) or Dbvisit…

Read More
Oracle Team

When PDB name conflicts with CDB name

By | Business Intelligence, Oracle | No Comments

By Franck Pachot . Going to multitenant architecture is not a big change. The administration things (DBA, monitoring, backups) connect to the CDB and the application things connect to the PDB. Without the multitenant option, it is still recommended to go to the CDB architecture. The non-CDB is deprecated and the multitenant architecture brings interesting features. People often ask how to name the CDB and the PDB, especially when they have naming rules or policies…

Read More
David Barbarin

Les 24 heures du PASS (24HOP) – édition francophone

By | Business Intelligence, Database management, Development & Performance, Technology Survey | No Comments

Je n’ai pas encore blogué sur le sujet mais il est temps de le faire. Cette année, aura lieu la première édition francophone des 24h du PASS  les 20 et 21 septembre 2016. L’idée est plutôt simple: proposer une série de 24 webinaires gratuits de 10h jusqu’à 22h (heure française)  pendant 2 jours. C’est l’occasion de recevoir et d’échanger les dernières informations autour de l’administration et du développement des bases de données, des nouvelles tendances côté Business Intelligence…

Read More
Stéphane Haby

SQL Server 2016: new tools management strategy

By | Business Intelligence, Database Administration & Monitoring, Database management | No Comments

A lot of customer’s feedbacks are about difficulties to find easily SQL Server tools. Now, it is easier… A unified web page for SQL Server Tools The first good news is that Microsoft unified and gathered these tools for SQL Server on a single web page: As DBA, this page is absolutely to be marked in your browser. The two major tools, SQL Server Management Studio (SSMS) and SQL Server Data Tool (SSDT), are…

Read More
Matthieu Munch

Oracle Data Integrator – The EL-T tool from Oracle

By | Business Intelligence | One Comment

Oracle Data Integrator is the ETL tool that Oracle has developed to enter into the world of Business Intelligence. Taking advantage of its incredible experience in database managing, Oracle has created an ETL tool that is flexible to use, powerful and that allows the integration of data coming from another sources.  Agility of use Oracle Data Integrator uses various types of graphical interfaces during all stages of data flow creation. Here is an example of…

Read More
Oracle Team

DBA, turkeys and NoSQL hype

By | Business Intelligence, Database management, Oracle | No Comments

By Franck Pachot . We (DBAs) look at this NoSQL hype with a large smile. We know how powerful are SQL databases and we can’t imagine processing data seriously without it. And the technologies that come with NoSQL brings back the problem that we have solved with SQL databases. But can’t we ignore what is currently going on. Behind the Big Data buzzwords there are real requirements. And if we refuse to listen to them,…

Read More
Microsoft Team

SharePoint 2013 – Office 365 & Power BI

By | Business Intelligence | No Comments

Quick reminder of what is SharePoint 2013 and Office 365 SharePoint 2013 SharePoint 2013 is a collaborative platform that allows organizations to increase the efficiency of their business processes. link: Office 365 with SharePoint 2013 This is the Online version of SharePoint 2013. When you sign in to Office 365, or your organization’s corporate intranet site, you’ll see links to Newsfeed, OneDrive, and Sites in the global navigation bar. These are your entry points…

Read More