Change Data Source via ODBC DSN - preview

If all goes well during our final testing :crossed_fingers:, in the next day or two, we’ll be releasing an update which includes the first change tool: Change Data Source

As announced late June, it will initially support ODBC DSN and with System and User DSNs supported. We do plan on adding support for File DSNs at some point, however as we don’t think that many of our existing desktop tools customers use File DSNs, we’re planning on focusing attention on the next change tool(s) and improving this one. But we’d love your feedback on whether that’s a priority for you so please do let us know.

For those familiar with how our desktop Change Data Source / Database conversion and migration wizard worked, the premise is similar in concept but we’ve significantly reduced the complexity and are only doing a set location (for now? let us know if you require more).

As with other .rpt Inspector Online tools, you start by selecting the report(s) for which you want to make a data source change and then click on the Change Data Source tool in the left side navigation. Then you specify the connectivity method (for now only ODBC is available), specify the tables in the reports to affect, specify the destination System or User DSN, and then specify the user name and password for the destination DSN.

.rpt Inspector Online’s Change Data Source tool will then proceed to make the changes you requested.

This tool carries our labs icon, which means that you should make sure that you backup your reports before using as we’re still testing this tool and evolving its features. We’d love to hear your thoughts.

Here’s a peak at how it looks… The below screen shot shows changing 21 tables across 12 reports from an ODBC DSN called Xtreme Sample Database 11.5 which is using an Access Database to an ODBC DSN called SF Demo Reports - SQLServer2016 which is using a SQL Server Native driver for SQL Server 2016. The source report(s) tables don’t have to only be based on ODBC DSN, they can be OLE DB and Native Driver too though as of now we’ve done limited testing and would love for your help here as well as further testing reports built on views and stored procedures.

:tada: Happy to announce that we’re doing final installer packaging and testing of the broker and server changes around Changing Data Source via ODBC and expect to have the updates in place in a few hours.