Error message when trying to define settings of a external system table

Marco_13112001
Marco_13112001 Member
edited December 2023 in General

Hi,

We have connected one of our systems with Aperture, the connection is sucessfull and I can see 220 tables but when trying to go through the define seetings step I'm receiving the following error message.

[ApertureDataStudio][SQLServer JDBC Driver][SQLServer]Invalid object name 'table name'

Is that an error produce by a bad connection with the external system or something wrong with the source database?

Many thanks in advance for your help

Best regards,

Marco

Answers

  • henry_
    henry_
    edited May 2023
    Hi @Marco_13112001
    The most common solution here is to check the "Force JDBC schema name" setting in the external system's configuration.

    https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/get-started/configure-external-systems/#microsoft-sql-server_invalidobjectname

Categories