Using the CData ODBC Drivers on a UNIX/Linux Machine This article shows how to use the pyodbc built-in functions to connect to Microsoft OneDrive data, execute queries, and output the results. With the CData Linux/UNIX ODBC Driver for Microsoft OneDrive and the pyodbc module, you can easily build Microsoft OneDrive-connected Python applications. As always, before running random scripts on your system, pull them down and read them first.The rich ecosystem of Python modules lets you get to work quicker and integrate your systems more effectively. Rclone packages their client as a binary and you can either download it from here for your system or you can use this handy script that they created. This means that I can use one tool for OneDrive, Azure, and AWS which decreases the cognitive load of having to know multiple tools. This is appealing to me since I do development against Azure and AWS. The beauty of that is not having to install multiple tools if you need to do work with other cloud storage. Rclone is an interesting project as it provides integrations for 30+ cloud storage providers. I personally only used the automatic sync with a simple setup which mimics how I use it with Windows. All of that can be found on the GitHub page. There is plenty of configuration options and the ability to sync multiple OneDrive accounts, etc. That’s it for getting up and running with the OneDrive Free client. Oct 27 00:20:10 odc systemd : Started OneDrive Free Client. To install the systemd service you can just follow what is in the GitHub page. The creator of this client knew that doing it manually would be a turn off, so they created a systemd service that you can install to make it a system service that will automatically start with the OS and keep your files synced. Unfortunately, this is still a manual process at this point and what we really want is for it to be automagic like it is on Windows. This will create a OneDrive directory in your home directory that will be used to sync your files. Once that is finished you now have the OneDrive Free client functioning with your OneDrive. You will need to copy that URL and paste it back into terminal as the response URI. You will be redirected if you give it the permission to a blank page. What this is doing is providing you a URL that you paste into your browser that will prompt a login into OneDrive and then ask for you to grant permission for the OneDrive Free client to access your OneDrive. We will be following the instructions on the GitHub page with one exception, make sure you install build-essential so you have make available. The first step is that you will need to install all the necessary packages for building the software, so let’s get that all installed. OneDrive Free Client is pretty cool and provides all the functionality that I could want, it works equally well with OneDrive and OneDrive for Business, with the latter being my primary experience. I will be primarily using Ubuntu 18.x for this discussion, however, there are instructions for other distros on the websites. Let’s dive in and see how to install and configure both clients. The biggest difference between the two would be the automatic sync that is provided by OneDrive Free Client and the fact that you will need to compile OneDrive Free Client yourself. ![]() Those solutions would be Rclone and OneDrive Free Client. Neither of those last two options are appealing to me right now, so let’s see what options we have.Īfter doing some research there are primarilyy two options that have emerged as the best choices, in my opinion. That leaves me with using a non-official solution or switching to back to DropBox or just setting up my own NextCloud. One big issue with many of these storage options is that DropBox is the only one with a native Linux client which is really unfortunate. However, I have determined that OneDrive is the best solution for my needs. In the past I have used Google Drive, then I started using DropBox more. I am a big user of OneDrive, primarily because of the amount of storage for the price.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |