Trouble Viewing Images? Right-click on any image and select "Open in new tab" to view a larger version. You can also zoom in using Ctrl + Mouse Wheel for easier readability.
Article Goal
This article explains what Connection Profiles are in VDM, which data sources are supported, and what to consider when configuring them securely.
What Is a Connection Profile in VDM?
A Connection Profile in VDM is a saved configuration (commonly referred to as a connection string) that stores the information required to connect to a database.
Key Components
A connection profile typically includes:
- Connection type (e.g., SQL Server, Oracle)
- Server or host name
- Authentication credentials
- Optional settings, such as schema selection or advanced configuration options
Creating a Connection Profile
Connection profiles are created and managed using the Connection Wizard, which is accessible from the Database ribbon bar within VDM.
Why Use Connection Profiles?
Connection Profiles simplify and secure how users interact with databases in VDM.
Key Benefits
- Eliminate repetitive setup – Avoid re-entering connection details each time you access a database
- Consistent connectivity – Support multiple database types using a standardized configuration format
- Enable MDS views – Leverage saved profiles to build Multi-Database Source (MDS) views
- Enhance security – Enforce machine-level restrictions to prevent unauthorized profile sharing
Connection Profiles are essential for querying, reporting, and visualizing data within VDM.
Supported Data Sources and Platforms
This article lists the supported data sources, database systems, and connectivity options available for integration, reporting, and analytics.
- Datasent
- InterProse ACE
- InterSystems Caché
- InterSystems DeepSee
- InterSystems IRIS
- InterSystems IRIS BI
- InterSystems IRIS for Health
- MySQL
- Microsoft Access
- Microsoft OLE DB for ODBC
- Oracle
- RevQ SaaS
- Rocket U2
- Select Platform
- Snowflake
- Standard ODBC
- SQL Client
- Web Reports
ODBC and Client Driver Considerations
When using Microsoft OLE DB for ODBC or Standard ODBC, ensure the following requirements are met before creating a connection profile:
- The appropriate ODBC driver is installed on your Windows machine
- A DSN (Data Source Name) is properly configured using the Windows ODBC Data Sources utility
Note: If you need assistance with driver installation or DSN configuration, contact your database administrator or refer to your database vendor’s documentation.
Notes
- Feature availability may vary by platform.
- ODBC connectivity allows integration with additional compatible data sources.
- Ensure required drivers and credentials are properly configured before connecting.
⚠️ Important Security Restriction
🚫 Connection Profiles Are Machine-Specific
Connection profiles can only be used on the computer where they were created.
This is an intentional security control to prevent profiles from being copied or transferred between systems to gain unauthorized database access.
🔒 Required Practice:
Always create and manage connection profiles on the system where they will be used.
Article Summary
This article provides an overview of Connection Profiles in VDM, which store connection strings and credentials to access supported databases. It covers supported database types, explains the need for ODBC/DSN setup when applicable, and emphasizes that connection profiles are secured to the machine on which they were created.
Comments
0 comments
Article is closed for comments.