2024 is the year of the connector - vote here

Knowledge base

Microsoft Access

To get your Katana Cloud Manufacturing data into Microsoft Access, you can simply use the _External Data_ feature with an _ODBC Connection_. > **Before you start:** things like this generally go better if you are running MS Access as an Administrator :) First, you'll need to [get your database credentials](/kb/startreporting?api=katana) from SyncHub. Next, go ahead and enter them into MS Access: 1. Select _External Data - New Data Source - From Database - Azure_ from the Access ![](https://api.synchub.io/Media/RenderFile?&documentGuid=1917be1e-eabc-4390-8654-d3568c5c8e56&clientID=4&) 1. We recommend importing the data to your local computer. This will reduce the latency of your queries and give you additional options around indexing etc later ![](https://api.synchub.io/Media/RenderFile?&documentGuid=ddc1763c-1b98-48a1-87a2-68aad13d85a3&clientID=4&) 1. The _ODBC Data Source_ screen will pop up. Create a new _Machine_ data source ![](https://api.synchub.io/Media/RenderFile?&documentGuid=287fa55d-203e-48a5-b918-1c64b177b7fb&clientID=4&) 1. It doesn't matter if you choose _User_ or _System_ data source ![](https://api.synchub.io/Media/RenderFile?&documentGuid=a10433a2-9f55-4547-8e4a-bf6aa449ea73&clientID=4&) 1. Select the most recent _Sql Server_ ODBC driver type. At time of writing, this is v17 ![](https://api.synchub.io/Media/RenderFile?&documentGuid=71a160e2-3062-4e8d-bf86-f4c05e2ee3d2&clientID=4&) 1. The _Server_ is provided on your _SyncHub Connection Settings_ - see our [quickstart guide](/kb/quickstartguide?api=katana) ![](https://api.synchub.io/Media/RenderFile?&documentGuid=1d81ee79-f4b1-4940-9f5d-175f1788d1f0&clientID=4&) 1. Make sure you select _SQL Server Authentication_ when prompted. Again, you can get these in our [quickstart guide](/kb/quickstartguide?api=katana) ![](https://api.synchub.io/Media/RenderFile?&documentGuid=e7e47aa5-6022-4294-9eae-c7a798053be6&clientID=4&) 1. Remember to set the _Default_ database **and** configure it for _Read Only_ access ![](https://api.synchub.io/Media/RenderFile?&documentGuid=ac0ef6df-d192-4e45-acde-21c49239745b&clientID=4&) 1. You can leave all the other settings on this and the next pages at their defaults. From here, you'll be able to browse tables and bring in the data you need. Have fun!