Connecting to a database with a different schema

SpeedySteven
SpeedySteven Member
edited December 2023 in General

Is there a setting that needs including to be able to pull data from a different schema from the same database? I keep getting an invalid object name error - I've attached the setup.

LightSpeed Connection issue.docx


Best Answer

  • henry_
    henry_
    Answer ✓
    Hi @SpeedySteven
    It looks like you'll just need to set the Force JDBC schema name setting in the external system's configuration - see https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/get-started/configure-external-systems/#microsoft-sql-server_invalidobjectname

Answers

Categories