SQL Server Integration Services

SQL Server Integration Services

SQL Server Integration Services (SSIS) es una solución de integración de datos ofrecida por Microsoft como parte de su ecosistema SQL Server. Esta herramienta ETL (Extracción, Transformación y Carga) permite el diseño, desarrollo y ejecución de flujos de trabajo que consolidan datos estructurados y no estructurados de diversas fuentes en una única plataforma. Destaca por su interfaz gráfica intuitiva, su consistencia para la integración y su capacidad de procesamiento transaccional, asegurando integridad en las operaciones..

Ibexa se asocia con Raptor para lanzar Ibexa CDP

Oslo, Noruega.- 14 de julio de 2022.- Ibexa, el proveedor de la plataforma de experiencia digital (DXP) dedicada a B2B, anunció hoy que ha llegado a un acuerdo con Raptor Services para licenciar su plataforma de datos de clientes (CDP). Ambas organizaciones son propiedad de QNTM Group y esta es una colaboración de gran importancia para las dos empresas hermanas.

Microsoft SQL Server

SQL Server Management Studio (SSMS)Microsoft SQL Server es el sistema gestor de base de datos relacional clásico de Microsoft, y una de las bases de datos más vendidas del mercado.

La base de datos funciona en modo de servidor, sólo , proporcionando servicios de acceso y manipulación de datos y estructuras, que se pueden utilizar desde aplicaciones o herramientas cliente como SQL Server Management Studio, SQLCmd..

The Oracle listener

In order to access to the same database where are you working outside the database server you must activate the service called listener, it has to be listening.

It can happens that the database is properly raised and can not connect from other servers, which are also set correctly (correct TNSNAMES, etc.).. 

In these cases could be that the listener has a problem, or simply has not been initiated.

To Check the status, start or stop it is very simple. Just open a command line session (console terminal, etc..) with the user that has installed the database, and run the lsnrctl command with the following parameters:

  • Check your state:
      > lsnrctl status

  • Stop the listener:
      > lsnrctl stop

  • Start the listener:
      > lsnrctl start

Keep in mind that when you stop the listener, the connections that are already in the database won't be closed, so a short stop is not very traumatic, only connections trying to enter while the listener is stopped are rejected, should not affect anyone who already has an opened session.

Quiterian launches a health business unit in the US

The company combines its expertise in the European healthcare industry with Quiterian DDWeb’s analytical capabilities to provide the US organizations with specific and customized business solutions
 
Miami, FL, July 20, 2011 – Its expertise in the European health sector, public and private, has led Quiterian to develop a strategic health business unit in the US Eastern coast, that will be conducted from the US headquarters, in Miami (FL)
Since its foundation in the year 2003, Quiterian has achieved a large number of successful experiences within the European healthcare industry, both in public and in private institutions. Many clinics and hospitals, blood and organs banks, mutual insurance companies and other healthcare services have taken a stake on Quiterian DDWeb and on its advanced and predictive analytics solutions for non-technical users and analysts.