検索

Discussion (3)0
Connectez-vous ou inscrivez-vous pour continuer
Question
· Juin 7, 2018

JDBC Authentication to AD to access exteral database

#Authentication #JDBC #SQL #Ensemble

Without installing Kerberos has anyone Authenticated a SQL JDBC connection? Currently we are using local SQL Accounts to sign onto External SQL Databases, but we are being told that we need to switch to Service accounts that live on a Active Directory Domain. 

I wrote with a little help a ZAUTHENICATE to do the Authentication for Ensemble, can I use something like that to connect to an External SQL Database using a Service Account on a Active Directory Domain?

Thanks

Scott

3 Comments
Discussion (3)1
Connectez-vous ou inscrivez-vous pour continuer
Question
· Juin 4, 2018

Cache Database and SSMS Integration Services Catalogs (SSIS)

#ODBC #SQL #Caché

Hi Everyone,

I am trying to built a SSIS package thru BIDS Visual Studio 2013. My Datasource is a InterSystems Cache Database, I wanted to Import Tables records from the Datasource to MS SQL Server 2014.

As a Sanity check. I only created one Package to import one Table to MSSQL Server to try out. The connection to the InterSystems Cache Database was successful. The DSN for the InterSystems Cache Database is created in the System for 32 and 64 Bit.

Here is where my Problem lies. I can successfully execute the SSIS Package in the BIDS Visual Studio 2013 BUT when i deploy the SSIS Package into the Integration Services Catalogs in the SSMS (SQL Server Management Studio) i get the following errors:

I tried so many Options but it just doesnt fix the Problem. It seems that the SSMS Integration Services Catalogs cannot recognize my Datasource BUT why?

Thanks for any tips and help. Thanks a lot in advanced!

6 Comments
Discussion (6)0
Connectez-vous ou inscrivez-vous pour continuer
Article
· Mai 14, 2018 2m de lecture

Continuous Delivery of your InterSystems solution using GitLab - Index

#Gestion des modifications #Livraison continue #Intégration continue #Déploiement #Git #Administration du système #Test #Tutoriel #Caché #InterSystems IRIS

In this series of articles, I'd like to present and discuss several possible approaches toward software development with InterSystems technologies and GitLab. I will cover such topics as:

  • First article
    • Git basics, why a high-level understanding of Git concepts is important for modern software development,
    • How Git can be used to develop software (Git flows)
  • Second article
    • GitLab Workflow - a complete software life cycle process - from idea to user feedback
    • Continuous Delivery - software engineering approach in which teams produce software in short cycles, ensuring that the software can be reliably released at any time. It aims at building, testing, and releasing software faster and more frequently.
  • Third article
    • GitLab installation and configuration
    • Connecting your environments to GitLab
  • Fourth article
    • Continuous delivery configuration
  • Fifth article
    • Containers and how (and why) they can be used.
  • Sixth article
    • Main components for a continuous delivery pipeline with containers
    • How they all work together.
  • Seventh article
    • Continuous delivery configuration with containers
  • Eighth article
    • Continuous delivery configuration with InterSystems Cloud Manager
  • Ninth article
    • Container architecture
  • Tenth article
    • CI/CD for Configuration and Data
  • Eleventh article
    • Interoperability and CI/CD
  • Twelfth article
    • Dynamic Inactivity Timeouts

In this series of articles, I covered general approaches to the Continuous Delivery. It is an extremely broad topic and this series of articles should be seen more as a collection of recipes rather than something definitive. If you want to automate building, testing and delivery of your application Continuous Delivery in general and GitLab in particular is the way to go. Continuous Delivery and containers allows you to customize your workflow as you need it.

Discussion (0)1
Connectez-vous ou inscrivez-vous pour continuer
Question
· Mai 14, 2018

Getting custom messages from a SQL Procedure

#Débutant #Opérations d'entreprise #SQL #Ensemble

I have  a SQL  procedure that I call into and it does some processing and passes back any data validations that fail. I would like to receive those message in my operation and act upon the message received .The question is how do you get output messages from a stored procedure I am using MsSQL 2012  with ensemble

3 Comments
Discussion (3)1
Connectez-vous ou inscrivez-vous pour continuer