Accessing SFMC business units within enterprise account with ODBC driver

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
dejan
Posts: 6
Joined: Mon 04 Dec 2017 15:50

Accessing SFMC business units within enterprise account with ODBC driver

Post by dejan » Mon 04 Dec 2017 16:00

Hi guys,

I have a question regarding Devart ODBC driver for back-end access to sales-force marketing cloud. My company is potentially looking to purchase licence(s) for your product but I have a question regarding access to business units within enterprise 2.0 account, details below:

When I connect to enterprise 2.0 account via your ODBC driver, the back-end tables that I am able to see all belong to the parent (main) account. What happens if I want to see the tables that belong to one of the business units under the main account? Is there a way to do this?

Please advise.

Thank you,
Dejan

dejan
Posts: 6
Joined: Mon 04 Dec 2017 15:50

Re: Accessing SFMC business units within enterprise account with ODBC driver

Post by dejan » Mon 04 Dec 2017 20:10

I figured out the problem here, you need to have a user account that is specifically set to show only business unit, not the parent account.

MaximG
Devart Team
Posts: 1025
Joined: Mon 06 Jul 2015 11:34

Re: Accessing SFMC business units within enterprise account with ODBC driver

Post by MaximG » Tue 05 Dec 2017 15:00

Currently, Devart ODBC Driver for Salesforce Marketing Cloud supports authentication using a username and password. Therefore, after configuring the DSN, you will be able to get access only to those objects that belong to the user specified in the DSN. In the next version of our driver we will add AppCenterClient authentication.

dejan
Posts: 6
Joined: Mon 04 Dec 2017 15:50

Re: Accessing SFMC business units within enterprise account with ODBC driver

Post by dejan » Tue 05 Dec 2017 15:41

Great, thank you for your response.

MaximG
Devart Team
Posts: 1025
Joined: Mon 06 Jul 2015 11:34

Re: Accessing SFMC business units within enterprise account with ODBC driver

Post by MaximG » Wed 06 Dec 2017 13:52

Feel free to contact us if you have any further questions about our driver.

Post Reply