Azure SQL DB data into Adobe InDesign

[Sandeep009]

Hi Team,

I am currently working on a client project that has unique reporting/printing needs.

My data is stored inside the Azure SQL database server. How can I connect the Adobe InDesign tool to the Azure SQL DB data? Is there any inbuilt connector available inside Adobe InDesign? Or, is there any third party connector available in the market?

I would greatly appreciate it if you could provide any input on the same.

Thanks,

Sandeep

[Creamer Training]

Check out: 

• Em Software
• 65bit
• Teacup Software

Another option would be to use Microsoft Excel to connect to the database--it has options build in . Then place the Excel file into InDesign by linking to the Excel file. 

[Manan Joshi]

If you want to develop something yourself then you can take the following route

• Create a CEP extension, query the Azure DB using the JS connector. Look at https://docs.microsoft.com/en-us/azure/azure-sql/database/connect-query-nodejs?tabs=macos
• Create a C++ plugin, this will be needed if you have to make the solution run in IDS server as well. In this you have endless possiblites as the C++ language should have binding for the said DB. You could also create a C# dll load it and use it inside the plugin if this is just a windows solution

-Manan