<p>Once I needed to create a program to download data fro external database into my own. It happened to be very easily.</p>
<p>In DBACOCKPIT transaction create a new connection to a database.</p>
<p>And user it in ABAP like this:</p>
<p>EXEC SQL.<br />
CONNECT TO &#8216;BSK&#8217;<br />
ENDEXEC.<br />
EXEC SQL.<br />
SET CONNECTION &#8216;BSK&#8217;<br />
ENDEXEC.<br />
EXEC SQL.<br />
SELECT db_name() INTO :DBN FROM SVERS<br />
ENDEXEC.<br />
WRITE: / &#8216;current database name&#8217;, DBN.<br />
EXEC SQL.<br />
SET CONNECTION DEFAULT<br />
ENDEXEC.<br />
EXEC SQL.<br />
SELECT db_name() INTO :DBN FROM SVERS<br />
ENDEXEC.<br />
WRITE: / &#8216;current database name&#8217;, DBN.</p>
<p>It&#8217;s basic Native SQL ? ABAP. Some SAP notes for reference.</p>
<p>Note 178949 &#8211; MSSQL: Database MultiConnect<br />
Note 323151 &#8211; Several DB connections with Native SQL</p>