Using the Query Database object on 64-bit Windows Server

I was trying out the Query Database object to see how I could get some information from Configuration Manager’s database, and I decided to use the ODBC connection type, since it seemed like something that would be more usable from an enterprise perspective than putting credentials in the object itself. I went through the typical…

3

Overview of Opalis Integration Server connectivity requirements

This article outlines the connectivity requirements for the various Opalis Integration Server components to interact with each other.  If firewalls exist between the various components, rules may need to be introduced in your environment in order to allow the components to communicate. The core components of an Opalis Integration Server implementation are: Microsoft SQL Server…

0

Working with Databases

Caution Test the script(s), processes and/or data file(s) thoroughly in a test environment, and customize them to meet the requirements of your organization before attempting to use it in a production capacity.  (See the legal notice here)   Note: The workflow sample mentioned in this article can be downloaded from the Opalis project on CodePlex: …

1

MS SQL Server Dump / Copy / Load

Caution Test the script(s), processes and/or data file(s) thoroughly in a test environment, and customize them to meet the requirements of your organization before attempting to use it in a production capacity.  (See the legal notice here)   Note: The workflow sample mentioned in this article can be downloaded from the Opalis project on CodePlex: …

0

Microsoft SQL Server Cluster Patching

Caution Test the script(s), processes and/or data file(s) thoroughly in a test environment, and customize them to meet the requirements of your organization before attempting to use it in a production capacity.  (See the legal notice here)   Note: The workflow sample mentioned in this article can be downloaded from the Opalis project on CodePlex: …

0