Connecting Azure Data Factory to Deltek Vision ERP using ODBC

dsp21 0 Reputation points
2024-02-06T15:45:48.1866667+00:00

Hi all, I am trying to move data from Deltek Vision database which is hosted on Deltek cloud to Azure SQL DB using Data Factory. I have ODBC connection access to Deltek Vision and installed HDP Hybrid Data pipeline. I want to know how I can connect to Deltek Vision as a source into the data factory. If I select ODBC as a source in Data factory, what would be the connection string? Any help is appreciated as I am currently stuck in my work due to this.

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,070 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Vahid Ghafarpour 14,610 Reputation points
    2024-02-06T23:28:58.5866667+00:00

    Thanks for posting your question in the Microsoft Q&A forum.

    I hope this article helps you:

    https://help.deltek.com/Product/TalentManagement/Documentation/Configure%20the%20ODBC%20Client.html

    ** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **

    0 comments No comments

  2. Pinaki Ghatak 2,150 Reputation points Microsoft Employee
    2024-02-07T07:29:36.49+00:00

    Hello dsp21

    To connect to Deltek Vision as a source in Azure Data Factory using ODBC, you need to create a linked service to an ODBC data store. Here are the steps:

    1. Browse to the Manage tab in your Azure Data Factory or Synapse workspace and select Linked Services, then click New.
    2. Search for ODBC and select the ODBC connector.
    3. Configure the service details, test the connection, and create the new linked service.

    For the connection string, you can specify it with a pattern like Driver= {SQL Server};Server=Server.database.windows.net; Database=TestDatabase;, or use the system DSN (Data Source Name) you set up on the Integration Runtime machine with DSN=<name of the DSN on IR machine>;. You need to still specify the credential portion in the linked service accordingly.

    Please note that you need to have a 64-bit ODBC driver for the data store installed on the Integration Runtime machine1.

    Also, ensure that you have enabled ODBC Connectivity for the user account in Deltek Vision.

    Remember to replace the placeholders in the connection string with your actual server name, database name, and credentials.

    I hope this answers your questions and helps you in your Azure Data Factory solution.

    0 comments No comments