When we create SQL Adapters we need to have integrations to the DB of the tools.What are steps to be followed and important things to kept in mind while doing so?
Unfortunately, there aren't out-of-the-box integrations provided. But here's a tech document on an example for pulling the SOI data, which may help you:
BSI and SOI integration and Alarm example
And here's an older Communities discussion where the SDM Green Book describes how to link an older release of SDM as a BSI data source; the procedure would still work on the current releases.
BSI 8.3 and SD integration
thanks and regards
Thank you for the tecdocs.
Could you please clarify that the highlighted area marked in the attachment is by default in the Data Link Properties or do we have to configure it ourselves?If so, then how?
Thanks and Regards,Sushank Saini
That's where you can specify an existing ODBC DSN. You can run "Set up ODBC data sources (32 bit)" at the OS level to define it.
Thank you but could you be kind enough to elaborate on this?
here's a Microsoft TechNet doc on how, if you've not used them before:
Lesson 1: Creating a SQL Server ODBC Data Source
Retrieving data ...