In den letzten Jahren hat PostgreSQL in fast jedem Unternehmen Einzug gehalten und wird dabei vielseitig eingesetzt. Da aber in der heutigen Zeit zumeist mehrere Datenbank-Systeme zum Einsatz kommen, stellt sich schnell die Frage, wie Daten einfach zwischen diesen Systemen ausgetauscht werden können. PostgreSQL implementiert Teile der SQL/MED- pezifikation, die sich genau mit diesem Thema beschäftigt – und genau darum soll es in diesem Artikel gehen: Wie schaffe ich es, PostgreSQL und Oracle so zu verbinden, dass ich einfach Daten in beide Richtungen austauschen und bearbeiten kann?
Boost your knowledge!
How? Let's check our Oracle, Microsoft, Open Source DB and OS workshops in detail!
Newsroom – dbi services news & events
Nach meinem Einstieg in die Welt des Oracle-Datenbank-Tunings vor 20 Jahren habe ich mich entschlossen, ein neues RDBMS anzuschauen. Mein Kollege Daniel Westermann, Team Leader des Open-InfrastructureTeams, der schon länger mit PostgreSQL unterwegs ist, hat mich überzeugt, mir PostgreSQL anzugucken. Da das Tuning mein Lieblingsbereich ist, habe ich Daniel gebeten, für dbi services einen „dbi InSite PostgreSQLTuning-Workshop“ zu schreiben. Bei dbi services gibt es für jeden neuen Workshop einen Dryrun. Während dieses Dryruns wurde mir klar, dass ich das PostgreSQL-Tuning vertiefen werde, weil es sehr ähnlich wie Oracle aufgebaut ist, somit werde ich den „dbi InSite PostgreSQL-Tuning-Workshop“ auch selbst geben können
Häufig werde ich nach „besten Praktiken“ gefragt – eine Frage, die mir unangenehm ist, da die Antwort in der Regel vom Kontext abhängt. Ich kann natürlich verschiedene „Standardpraktiken“ empfehlen, die sinnvoll sind, wenn es keinen besonderen Grund gibt, anders vorzugehen. Meist geht es dem Fragesteller jedoch um einfache, allgemeingültige Regeln, die sich immer und überall anwenden lassen. Wenn es um generelle Empfehlungen geht, zähle ich lieber Dinge auf, die unter allen Umständen vermieden werden sollten. An dieser Stelle werde ich daher auf einige der „schlechtesten Praktiken“ eingehen.
dbi services obtains ISO 27001 certification and AWS Advanced Partner status
Delémont, 16 December 2020 – dbi services has set itself ambitious goals for 2020. This strategy has been successful as the company has not only achieved ISO 27001:2013 certification, but also AWS Advanced Consulting Partner status. These two milestones demonstrate the company’s ongoing commitment to its customers to provide them with cutting-edge security and expertise.
Data security for the company and its customers
ISO 20000 certified for nine years, dbi services takes a further step in terms of security by obtaining the ISO 27001:2013 label. This international standard guarantees the definition, implementation, updating and continuous improvement of the company’s information security management system. In addition to attesting to the ability of dbi services to implement the means required to guard against data breaches or leaks, this standard guarantees the application of best practices along with regular monitoring and constant updating of security measures and processes.
Dominique Althuser, Security Officer at dbi services, certified Lead Implementer and Lead Auditor
27001: “We are very proud to join the select club of ISO 27001-certified companies. Security has always been a central theme at dbi services, which is why we have endeavoured to achieve this certification. This allows us in particular to optimize the integration of all security aspects during the implementation of our customers’ middleware infrastructures.”
From AWS Select to Advanced Consulting Partner
True to its strategy of increasing its expertise, dbi services has set itself the goal of moving to the next level of its partnership with AWS by becoming an Advanced Consulting Partner. The exercise was met with success on 9 December, thanks to the commitment of all employees to meet the necessary criteria. Grégory Steulet, CFO and Partner Manager of dbi services: “Expertise has been part of our DNA since our creation. We have therefore made every effort to reach this level, which attests to our vast experience in the deployment of AWS products and to the cutting-edge expertise of our consultants, both at the technical and business levels.”
Yann Neuhaus, CSO and Vice-Chairman of the Board concludes, “This result also reflects our systematic awareness of the needs of our customers for reliable and secure Cloud solutions. With this new partnership level, we are confirming our ability to deliver them and ensure their optimum functioning”.
About dbi services
dbi services designs, builds and operates state-of-the-art middleware infrastructures so that its customers can focus on their core business. Its consultants’ expertise in Oracle, Microsoft, Open Source, Cloud and ECM technologies (including OpenText) enables it to offer tailor-made and effective solutions. dbi Services is based in Delémont, Basel, Bern, Nyon and Zurich and employs 80 committed employees whose knowledge and skills are constantly evolving through continuing education. Active in Switzerland, but also in Europe, dbi services has the trust of nearly 300 companies – SMEs or multinationals – operating in various sectors.
dbi services partners with Verium to accelerate growth strategy
Delémont, 3 December 2020 – A group of investors represented by the multi-family office Verium acquires a majority stake in dbi services. The founders and key employees remain substantially invested and will continue to develop the business together with Verium. The company intends to further expand its strong position in the Swiss market and to realize an ambitious growth strategy both organically as well as through add-on acquisitions.
Yann Neuhaus, co-founder and CSO of dbi services: “With Verium we found an experienced and financially strong partner with whom we are convinced to successfully achieve our growth targets. dbi services seeks to expand its geographical footprint and its technological expertise, organically as well as through buy & build”. Yann Neuhaus and his co-founders David Hueber (CEO), Grégory Steulet (CFO) and Hervé Schweitzer (CTO), together with selected key employees, retain a significant minority stake, continue to form the management of
dbi services and are committed to drive the company’s long-term development.
“We at dbi services will continue to differentiate ourselves through our team of certified and skilled IT specialists providing very high quality and expert-driven services with a clear focus on operating enterprise information systems and IT infrastructures” says CEO David Hueber. “Verium shares our entrepreneurial philosophy and cultural values and can support our future development both strategically and financially. We will continue to invest in our people, who are key to the continuing success of our company, in order to keep pace with the rapid development in technology and to provide best-in-class and innovative services to our clients”.
Verium strengthens the company’s board with Rogier Engelsma and Stephanie Roller. “With its strong market position, highly sticky customer base, blue-chip partner network and skilled employees dbi services is very well positioned to take advantage of market opportunities such as cloud migration and increasing complexity of IT infrastructures. We look forward to a fruitful collaboration with the dbi services team as the company enters an exciting stage in its growth path”, says Stephanie Roller, Investment Director at Verium.
About dbi services
Founded in 2010 and with offices in Delémont, Basel, Nyon, Bern and Zurich, dbi services is a leading Swiss IT management consulting expert for enterprise information systems based on Oracle, Microsoft, Open Source, Cloud and ECM (incl. OpenText) technologies. The company employs more than 70 certified and experienced IT specialists who design, realize, and operate cutting-edge IT infrastructures for SMBs and multinationals from various industries such as pharma, healthcare, insurance, banking, and the public sector. dbi services enjoys the trust of more than 300 customers in Switzerland, Germany, Benelux, Italy and France.
Verium is an independent multi-family office and manages direct investments in medium-sized companies in the DACH region for its investors. Latest investments include Home Instead, basefit.ch, Christ & Heiri, Toradex, Ceposa / Frische & Service, Quickmail, Mobil in Time / S&G, DSwiss and Zünd.
For this transaction, Verium was advised by Wenger & Vieli (legal), Alvarez & Marsal (financial and commercial) and PwC (tax). The sellers were advised by P4I Partners (M&A) and Tavernier Tschanz (legal).
Häufig werde ich nach „besten Praktiken“ gefragt – eine Frage, die mir unangenehm ist, da die Antwort in der Regel vom Kontext abhängt. Ich kann natürlich verschiedene „Standardpraktiken“ empfehlen, die sinnvoll sind, wenn es keinen besonderen Grund gibt, anders vorzugehen. Meist geht es dem Fragesteller jedoch um einfache, allgemeingültige Regeln, die sich immer und überall anwenden lassen. Wenn es um generelle Emp-fehlungen geht, zähle ich lieber Dinge auf, die unter allen Umständen vermieden werden sollten.
Learn how SQL Server 2019 has extended its features through virtualization by avoiding movement and data replication during their integration. Discover also a new virtual environment that is becoming increasingly important in a world where information must be consumed quickly. The seminar is held in French and in German.
Webinar Series – „Go Beyond by AWS CH“
Recordings available upon request (click on the links below).
dbi services and AWS offer two webinars as part of the “Go Beyond by AWS CH” series.
Find out what our experts have to say about Server Patching with AWS SSM (in German) and Oracle databases on AWS (in French).
- Simplify your work – Automatisches Server und Datenbank-Server Patching mit AWS SSM – Julia Gugel (in German)
- Oracle databases on AWS – Nicolas Jardot (in French)
Webinar Open Infrastructure (in English)
We are pleased to present you the new edition of our Open Infra Day. This year, our Open Source-oriented event includes three technical presentations exploring various topics such as Kubernetes, Suse Linux Enterprise and PostgreSQL.
AGENDA & SESSION DESCRIPTION
With today’s Dev/Ops approach, databases need to be provisioned and cloned instantly.
Developers often need new Postgres instances for development and testing purposes against a defined version. These must be readily available for testing and validation procedures. By combining PostgreSQL with the BRTFS filesystem on SUSE Linux Enterprise systems, this requirement becomes a no brainer.
This session will guide you through rapid provisioning and cloning using BRTFS subvolumes in an automated way. Wrap that into Ansible playbooks and database instances can be provisioned and cloned by everyone.
- Saïd Mendi, Consultant at dbi services
Traditionally PostgreSQL stores relations in a format called ” heap “. This comes with advantages, but also with drawbacks. One of the downsides is that every PostgreSQL DBA needs to deal with bloat at some point in time as updates generate new rows in PostgreSQL.
Zheap promises to eliminate most of this bloat. In addition, it claims to be superior for certain kinds of workloads by introducing undo segments. In various demos, we will go through the architecture of zheap, highlight its advantages and then do some tests, thus comparing heap and zheap.
- Daniel Westermann, Technology Leader Open Infrastructure and Principal Consultant at dbi services
Containers, Kubernetes and hybrid cloud. What’s behind the hype and how these technologies can help your business.
What are Containers and their benefits.
Why you need Kubernetes and what it can do.
Deploying, delivering, and scaling containers with OpenShift.
- Marius Lapagna, Solution Architect at Red Hat
The personal data sent via this form will be processed by dbi services and, where applicable, the partner sponsoring the event. dbi services may send newsletters and invitations by email or post, but you can unsubscribe at any time by following the instructions provided in the newsletter. In addition, dbi services may produce photos and/or video sequences for marketing purposes at the event concerned and you may appear in them in a recognizable manner. Your personal data is processed for the requirements of organizing the event and for marketing purposes. This data processing is justified by our legitimate interest to communicate with you, inform you about our activities and provide you with information relevant to your interests. You can oppose the processing of your personal data at any time by contacting us at [email protected].