How to create & setup Altium Database Library - Step by Step Tutorial

In this video, you will create and setup your own Altium Database Library using Altium + ODBC + MySQL server on Amazon AWS.
PS: If you are getting an error when installing ODBC driver, try to install MS Visual C++ Redistributable, it worked for me: support.microsoft.com/en-us/h...
------------------------------------------------------
Would you like to support me in what I do? It's simple:
- you will help me a LOT, when you sign up for one of our Schematic and PCB Design online courses at www.fedevel.com/academy/
The other ways to support me in what I do are:
- support me through Patreon page / robertferanec
- sign up for my Udemy course, Learn to Design Your Own Boards www.udemy.com/learn-to-design...
- send me an email and/or leave a positive comment
- watch and like the videos :)
- read my Welldone Blog at www.fedevel.com/welldoneblog/
- spread a word about FEDEVEL Academy
It is much appreciated. Thank you,
- Robert

[@michaelfrickel6039]

Finally a good guide on this topic. Thank you very much ! I would love to see a follow up !

[@matthollandsf]

Robert you did it again! I've been using csv files as a database forever. Setting up a real database is something I'd never done, and now that I've seen this video I know how to get one started. Amazing resource. Would love to see follow ups about those triggers or anything else a database newbie might not know about.

[@RobertFeranec]

Thank you very much Matt PS: Currently I had to move to A365 so my DB library is not being used.

[@adrianwong26]

I WOULD LOVE TO SEE THE FOLLOW UP VIDEO. Thanks for all your guidance Robert :)

[@borislysynski743]

Thanks for creating this... definitely better than sifting through Altium's documentation. A follow-up video would be appreciated.

[@justinmassiot]

Thanks Robert for this instructive video! I didn't even know a DbLib could interface an underlying MySQL database... As for the "not visible" parameter(s) at 49:24, I think the correct way to make them visible is to edit the DbLib file itself: check the "Visible on Add" checkbox for every parameter you want to get visible by default.

[@matthollandsf]

0:00 intro 1:45 AWS setup 5:58 MySQL Workbench setup 10:32 Add first component category (table) in MySQL Workbench 15:17 Install and configure ODBC Driver 18:57 Create and configure Altium dblib file 24:35 Dealing with bugs 26:53 Adding parts from "Manufacturer Part Search" panel 33:27 Setting up symbols and footprints

[@brokenicry]

WOW... I used this tutorial to learn how to create a Local DBLib using Access... I struggled for a few days before landing on this tutorial. You might not remember, but I am the same guy that used your OpenRex Design to practice PCB Design, from LinkedIn...Brunel Balukidi is my name. Thank you for all the content. I cannot afford most of your courses but the bit I can get my hands on has helped me tremendously. Thank you and Be forever blessed

[@RobertFeranec]

BrokenICry I am happy that you found the video useful

[@TheGorobin]

Very useful video. I would enjoy seeing a follow up that includes the organization of multiple component types!

[@chaochang1305]

use variant

[@TheCopperbolt]

I've benn looking/waiting for information on database libraries for a long time! Great video! The process seems a bit intimidating though. I would love to see a follow-up video very much!

[@RobertFeranec]

Thank you Adrian.

[@richard-sim]

Hi Robert - great video, this should be very useful! For anyone else stuck on right-clicking the vendor (Digi-Key) to select "Import Into ...", where no menu is shown at all, make sure that you are on Table Browser, not Field Mappings!

[@RobertFeranec]

Thank you Richard. Also, check if you have "Single key lookup" set to "Part Name" - I think, that also can create the same problem (?)

[@theondono]

MIND BLOWN at 26:00 I have set up multiple database libraries at this point, I had to create and use CRUD systems in php, access and others to handle the table management, and turns out it's all because Altium has a ridiculous bug no one has bothered to fix or document. Sometimes Altium makes you hate life too hard...

[@RobertFeranec]

Xavi, I agree, it's ridiculous. In my opinion, Altium is focusing to make money on vault, so they do not really bother much to fix or improve database interface in Altium. PS: This bug was one of the reasons why I almost gave up when preparing this video - but then I was lucky and I found a small note in Altium forum about this trick.

[@KostsovKonstantin]

Thank you very much for the video. You explained better than anyone what needs to be done.

[@efox29]

Would love to see a follow up this. Design is not only circuit connections but also the supporting frameworks, processes and workflows help it. I think this topic is something that alot of young engineers could really benefit from and even some more veteran ones too (me).

[@RobertFeranec]

Thank you efox29. Completely agree.

[@lukeh7638]

this was a perfect level of detail, thank you so much for your work

[@RobertFeranec]

Thank you Luke

[@GinoFavero94]

Thank you! I'm studing in Argentina and i want to be hardware engieneer. I was somewhat lost, i didn't know where start to lern (I only did two basic courses beafore) and your channel appeared. I will start with your free videos and i will go for your courses.

[@RobertFeranec]

Thank you very much Gino

[@izmiribl1104]

Thank you for your answer, Robert. I have created a case in Altium's support, but they only wrote, that they are very busy this time. As soon as they write me a real answer, I will tell you. So, I suppose (when you're working with database libraries) you "draw" (in fact copy and paste;) more than one identical symbols with different pin-designators/names, eg. "BJT_npn_B2C3E1" and "BJT_npn_B3C1E2" to fit 3-pin-BJT for different footprints. That's not very comfortable, but I'll start with this until I have more information. Meanwhile I can watch your videos and learn much more than from Altium's documentation ;-)

[@RobertFeranec]

Thank you Izmir

[@konstantinponomarev1087]

Thank you, Robert! It was very useful

[@urbietorbi123]

Thank you, I would love to see a follow-up video

[@Logkill]

Thank you Robert, it's very useful.

[@scottchaney501]

Very helpful video. I would be very interested in additional videos on libraries

[@RobertFeranec]

Thank you Scott

[@Jo-vk7jl]

Thanks for your useful guide. It helps me a lot!

[@firedeveloper]

I was trying to get familiar with DB libraries. After your video I hosted MySQL DB in hyperV Ubuntu and having fun in local network. Imagine what you can do by adding codes from your company ERP software in each Part, track your local stock, find in which shelf is stored, etc etc.... If you have your own assembly line the whole process is so much time consuming .... Also did a client to search ERPs from all tables in DB, its amazing !

[@RobertFeranec]

Exactly my goal of this video :)

[@8Radmir8]

Hello, Robert! Thanks a lot for a very useful video! It will be helpful to see new video about how to colobarate existing DBLib with Altum Concord. And how to update old AD-projects with data from new-created DBLib/Concord. Yes, it will be intresting to see how to effectivly management of components data/components sections, creating components templates (Concord).

[@RobertFeranec]

Thank you very much. PS: I was planning to make some videos about Concord PRO, but I decided not to use it in my company, so I would not have much examples for it.

[@runbren]

Great video. I'd like to see another video. It would be great to see an SVN library video

[@RobertFeranec]

There is nothing special about SVN. I am thinking to use GIT, keep one symbol / footprint in library and for different version I would just do like R0805 v1.PcbLib. I would also keep the original R0805.PcbLib, so old projects would be using the old footprint and new projects would be using new footprint.

[@runbren]

@@RobertFeranec what's the difference between using SVN and git? I'm currently using SVN. I know you can use git on the design files but can git work the same on a SVNDbLib?

[@RobertFeranec]

@@runbren I think, SVN has better support in altium, but I do not know if there are big advantages / disadvantages between these options - there are some differences, but nothing radical. Simply, I do not have SVN server and I already use github for our software development, so I was not really thinking about using SVN. And I would like to keep footprint / symbol version in separate files - so I can have easy access to each version of symbol/footprint, so I do not really need SVN for this.

[@michaelfrickel6039]

@@RobertFeranec Thats exactly the way i do it. Keeping the source files and a reference to the Database file in a git repo works very good. Easy access across multiple workstations ! You can use different branches to reference old files in a local repo for older projects.

[@m.bonita8527]

For the 3D Models, do I have to set up the path parameters in the database library? Thanks a lot for the great video!

[@adrienferreira4666]

Nice tutorial, still relevant in version 23.3.1, thank you very much!

[@TheIceiYT]

Super Video. I have added a progress database as source, but the part where you select Database type even if your are using a connect string was new to me. Now we just wish that Altium would make it possible to only select some fields, not all to import to our own database :-)

[@RobertFeranec]

I am planning to filter the imported parameters through database trigger - not ideal, but could work. Once I have it up and running I may do another video

[@TheIceiYT]

@@RobertFeranec I would love to see that and if possible something like alligment of different suppliers fields, cause they does not always call it the same. But maybe that is more a like SQL stuff :-)

[@crchen8349]

Hi Robert, thanks a lot for your sharing. I'm currently working on the DB lib as well, do you have any experience to include the simulation models in the DBLib? It seems more complicated than linking the symbol & footprint.

[@aytackorkmaz469]

Nice Job! Pretty detailed and informative, thanks.

[@RobertFeranec]

Thank you. I spent so much time on it - initially nothing worked in Altium and I had to figure out why altium is throwing so many errors and has so weird behavior. At the end it was not so bad as it looked when I started.

[@aytackorkmaz469]

@@RobertFeranec There is nothing to say. Really, big thanks for all of your effort.

[@mateuszkowalik7189]

Very helpful! I tried once and stucked at connection with AWS. Thank You very much!

[@RobertFeranec]

Thank you Mateusz. Yeah, it took me quite some time to figure out everything - especially the Altium part - Altium was crashing and throwing errors all around.

[@Stangrag66]

Robert, Thank you for your great video!

[@RobertFeranec]

Thank you Mike

[@martantoine9977]

Amazing content, thanks for everything

[@gabrieltovar1235]

very good work. There are not Tutorials for DBLibs creation. Even for us as Engineers working in Altium

[@RobertFeranec]

Yep, I googled for DBlib tutorial and could not find much info. PS: Nice to hear, that my videos also help people in Altium. Thanks.

[@gabrieltovar1235]

@@RobertFeranec Yes very nice for our support here in Germany :) . Maybe it would be useful another video using SVN DBLib. Greetings from our office in Munich

[@pranavmokashe1637]

great efforts thanks a lot !!!!!!

[@miworl]

Really interesting topic. Could you please publish the continuation?

[@IlijaPecelj]

thanks... in spite of all documentation on the altium website this video clarified things to me ...

[@RobertFeranec]

I also tried to use Altium documentation - took me almost a week playing around to figure out how it actually works and how to configure it to make it work.

[@IlijaPecelj]

@@RobertFeranec I'd definitely like to see a follow-up video if you think it's necessary. Particularly, if it's possible to hierarchically organize the database.

[@RobertFeranec]

I am not thinking to hierarchically organize components in Altium - I am planning to use Category Parameter, however I would only use it if I create a front end database interface for it. In Altium, I will simply use Description or Part name to check if component is in library - for searching I am planing to keep using digikey.

[@vimalamin7799]

Robert, Great Job. YOu changed my life !! Let me know about other videos that you made !!

[@reibax]

Great video! Thanks! I just struggle to understand a couple of things: - I would think the good thing about an online database would be that it enables collaboration between remote users, but how is this useful if the tables have references to relative paths to files in the local filesystem (symbols and footprint files)? - Is there any way to undo changes if you get something messed up because of a bugged import action?

[@andrealongobardi2084]

Great Video Robert Thanks!!! I use Altium for my one-person company, so no need to share library, do you see any issue in using a local MS Access database (I had it with my 365 subscriptions) other than the need to back it up regularly?

[@byatse3013]

thank you may i ask a question that in schematic library i choice resistor and than choice size footprint

[@patrickmagee774]

Fantastic, thank you.

[@nickagiann]

That's a very insightful video Robert, as always! And I would definitely be interested for a follow up 😊. I have a question though (not directly directed to you). What is the benefit of using a database library instead of a normal integrated one? I'm asking because I also want to setup a library system and would like to make a well thought decision. And what about the managed libraries?

[@RobertFeranec]

My main reason to move to DB library is, that more people can work on it. When we had one integrated library, only one person could work with it. Now I am trying to find a way that more people can create symbols and footprints at once - so I am testing DB library (I still have not found the optimum way to do it, but testing different scenarious). Also, when integrated library was growing, it was more difficult to work with it.

[@berkandincay]

@@RobertFeranec Cant you collab with Google drive or similar with folder share

[@aaronchoque8385]

Muchas gracias, me resulta de mucha ayuda, un saludo desde Argentina!!!! 🧉

[@thomasyunghans1876]

Wow Robert, How did you ever get through all those steps without making a mistake?

[@izmiribl1104]

Hello Robert, many, many thanks for this fantastic tutorial, it saved me weeks of reading and trying. You are great. I did the DbLib with Microsoft Access, it works as well. Now I'm struggeling with components that have more than 2 pins, which must be mapped, because symbol and footprint do not have the right numbering. In the integrated Library it is no problem, there is a pin map button in the model manager, but I do not see this when I work with DbLib. Do you know if there is a way to do this (maybe manually adding columns in the database)?

[@RobertFeranec]

Thank you very much Izmir. PS: I do not know, I do not use pin mapping :(

[@urbietorbi123]

How to add a second footprint to a component? Do I have to add a field name, something like "Footprint Ref 2"?

[@rickbarfield1034]

Deleted my comments, everything worked out! Great video, thank you so much. Altium should put you on their payroll.

[@RobertFeranec]

I am happy it worked. PS: My relationship with Altium is complicated ... especially because I do courses and they also do trainings.

[@rickbarfield1034]

@@RobertFeranec I completely understand that.

[@fatihgocmen1743]

thanks Robert. Can you show me how to do it with microsoft access in a closed local network system for use on several computers?

[@RobertFeranec]

I do not have MS access, but I guess it should be something similar.

[@TimNortonGuru]

Can I ask what the advantage of this over the standard schematic library?

[@caglauzun3454]

Hi Robert, Firstly Thank you for your videos. They are realy helpful for us. Could you information us about SVN data base library?

[@RobertFeranec]

Thank you cagla. I am not using SVN, that is reason why I used Github in the video.

[@antoniocontursi7477]

very interesting video Robert, i like very much and i hope you will make a follow up especially to understand how to organize library of symbols and footprint.

[@RobertFeranec]

Thank you very much Antonio. I am planning to record a follow up video ... I am still testing different ways of using db library in team and I am looking for an optimum solution.

[@forresterickson6225]

@@RobertFeranec I learned a lot about how to think of part number systems from the manual for a small part management database system called Parts & Vendors. They no longer sell their product, but you can find the manual here: www.trilogydesign.com/downloads/PV6Manual.pdf See page 48 for Tips For Better Part Numbering Systems. And see page 28 for Essential Concepts which is really an interesting example of useful fields. Having used a system based on this, I would make one change. An item would be in the CATalog (a part which is sold) should be a identified as such by a separate boolean field. Hope this helps.

[@forresterickson6225]

@@RobertFeranec I learned a lot about how to think of part number systems from the manual for a small part management database system called Parts & Vendors. They no longer sell their product, but you can find the manual here: www.trilogydesign.com/downloads/PV6Manual.pdf See page 48 for Tips For Better Part Numbering Systems. And see page 28 for Essential Concepts which is really an interesting example of useful fields. Having used a system based on this, I would make one change. An item would be in the CATalog (a part which is sold) should be a identified as such by a separate boolean field. Hope this helps.

[@forresterickson6225]

My mouse must bounce.

[@forresterickson6225]

My mouse must bounce.

[@rastislavmichalek9449]

Ahoj Robo, dobre si to urobil ;-)

[@RobertFeranec]

Dik Rasto :) Ako zijes? :)

[@robertobuerger757]

Hi Robert, Thank you for your awesome work. Your courses and videos helped me a lot in my projects. I am working with a friend in some projects and we wanted to share a database library. Do you have some references how to share a database library in a way without corrupt errors? Greetings from Brazil.

[@RobertFeranec]

thank you. I am thinking to use aws mysql + github. But I am planning to use triggers in mysql to do history tracking, cleaning database and separating clean database from Altium imports - if I have time I will make a follow up to this video. This what I am thinking about could work as a shared library and should be possible to track any changes or revert back if needed.

[@robertobuerger757]

@@RobertFeranec That would be nice and useful. Thank you very much!

[@tranucchinh3743]

@@RobertFeranec thank you! I hope you'll do that soon!

[@KasperPilsted]

Any ways to store the symbols and footprints inside a database too? this would make it easier to share the libraries, I am thinking.

[@spacedesigner849]

Quick question, I've setup everything as you said and it works fine, however, sometimes when adding new components in the DbLib file through Altium and you press "Save" suddenly the Symbol model and Footprint model dissapears and I get "Footprint is not present". I've tried refreshing, saving,etc.. nothing works except exiting and restarting Altium. Since setting this up I've literally been creating components -> Restart -> Add component, it's not sustainable and was wondering if you have faced the same issue? Thanks again, lots of love :)

[@antoniocolino3523]

Very interesting video!

[@RobertFeranec]

Thank you Antonio

[@techydude]

This was very helpful, thank you, though I'm not sure why you 'defaulted' to a cloud-hosted SQLdb (though later in the video it appears it might be because you're collaborating with someone in a different location, so that makes sense), but having the SQLdb cloud-hosted adds "you must have working and decent speed internet connectivity" to the things you need for Altium to work, which I generally avoid where ever possible :-)

[@silentkiel]

I'm quite sure that Robert chose AWS because this is already "preinstalled in the Internet". Otherwise he had to make a five hours long video about choosing a proper DBMS and install it.

[@techydude]

@@silentkiel “pré-installed in the internet”? hey, I have this box to sell you, the entire internet is in it! there’s no need for a 5 hour video deciding on a db, just go with the same MySQL he showed on AWS hosting, and the installation of MySQL is very simple and quick. As I said, defaulting to a ‘cloud hosted’ SQL instance just adds one more reasons why Altium could stop working, and frankly it doesn’t need any more reasons. But if you’re collaborating with someone in a different location, then sure.

[@silentkiel]

@@techydude You probably misunderstand the problem. Robert wanted to make a video about using an SQL database for Altium Designer purposes, not about installing a DBMS. Choosing AWS is an easy way to use a database without installation, and this is a feasible way for many people. Of course most people can decide afterwards if they want to install a local database server. Since AWS only stores the DbLib information and not the schematic and footprint libraries you also need a synchronized way to access those libraries, i.e. by using a VCS like Subversion (any AD) or Git (for >= AD 18). For my purposes I will of course use my local MariaDB server. The reason why I watched Robert's video was a link from EleLa: www.mmvisual.de/Hilfe/EleLa/TutorialDB/TutDBAltium.htm

[@silentkiel]

@@techydude *I* don't need your box. There are lots of "boxes" in our datacenter which also includes a MariaDB SQL server.

[@techydude]

@@silentkiel 3 weeks later and i think you still missed the joke...

[@7006608]

That was very helpful Robert! Is there a way to import the Symbols/Footprints as well from the manufacturer search into our library ? I was thinking to 'Acquire the parts into my workspace then 'Select All' and Download them in one compressed file then unzip the files into the folder. What do you think ? is there a better way ?

[@RobertFeranec]

I do not know. If you would like to use them, I would probably copy and paste symbols (that is not so difficult - you can place it from manufacturer search to your schematic and then copy and paste it into library), but it may be more difficult with footprints. PS: This video may also help: kzbin.info/www/bejne/Zp6uaZtme759fNE

[@7006608]

@@RobertFeranec Just checked the video, my idea was exactly your suggestion you made in 2012. Unfortunately seems they haven't implemented it yet.

[@somud1]

so, using this method we would have the component parameters stored in the cloud (price, links manufacturer PN etc... ) but not the footprint or the symbol? it this intentional? or am i missing something? Also, fantastic tutorial. i would be keen on a followup as well :)

[@RobertFeranec]

Thank you Somu. Yes, that is correct. Symbols and footprints need to be on local PATH. I have symbols and footprints on github and cloned on our local server. I believe, if you use SVNDbLib you can have symbols and footprints also on url, but I have not tried that.

[@samuelpivattocavilha5541]

Hello! I followed the guide (great job btw!) but it seems that the free AWS tier will expire in 12 months. Do you sugest an alternative?

[@thomasflatz8244]

Thanks for the video! It seems like the Amazon RDS cloud is only free for 12 months. Is this correct? What is the average pricing after that for a "normal" usage only for Altium libraries? Any experience with that? Thanks!

[@tantudaisu]

Please do follow-up video :)

[@emanuelaschenbrenner3285]

Thank you for the great Video! I have a problem. I only can commite the table of the MySQL-Workbench. When I edit the altium table browser I get an Error.

[@safwathabedin2198]

Hi Robert, what is your comment about Altium 365 library?

[@forresterickson6225]

Robert, Wow some heavy lifting on this one. At 49:45 you selected "Override Library Primitive". It is not clear what is going on here. Yes, the effect is that the comment becomes visible, but I do not understand what was going on "under the hood". What was the primitive that was being over ridden? What does override mean, ie who is overriding what where? What is the scope of this overriding? For example, is the scope this project? Also, unless I am missing something, your two parts have very different parameter list. Will this not cause problem generating BOM with the default spreadsheet template you provided in your LED tutorial series? ( I asked this same question on another library video an hour ago or so.) It would be great if you should show how (or provide a link to a video on how) to back up the database you just made as it is now very valuable (you would not want to have to recreate it.) Thanks again.

[@Daniel-ib5bx]

What is the advantage to this over server based libraries?

[@kristinazunino8060]

Hi Robert, have any of these steps changed since 2019. I am not on Altium 22 and wondering if this can still be implemented the same way

[@Dazzakb]

Hi Robert, thanks for the video, would it be possible to link Altium to a MS Access database?

[@RobertFeranec]

It should be possible, but I do not have MS Access, so can't try it. I would expect it to be similar to what I have done with MySQL.

[@IlijaPecelj]

kzbin.info/www/bejne/g6mTmJyZaLpmidU here is a video addressing this problem with the MS Access.

[@berkaysomali8911]

Thank you for the tutorial. Question: When you write the Library Ref and Symbol Ref as urls, it does NOT work, even if you write them as absolute links. Is there a way to keep all your footprints and symbols in the cloud too? I do not want to keep my footprint/symbols in a local drive and keep my database in the cloud. It makes no sense. It would be great if I kept everything in the cloud for having a central database location which can be accessed from anywhere.

[@RobertFeranec]

I agree. I have exactly the same issue with it. I think you can use url with SVN, but I do not want to use SVN.

[@tranucchinh3743]

@@RobertFeranec Can using SVN database Library instead of Database Library do the same way you do with database library with My SQL, ODBC driver and AWS cloud?

[@RobertFeranec]

@@tranucchinh3743 I have not tried that, but I would think it could be something similar.

[@spacedesigner849]

49:01 is the sound you make when you forget your child on the stove again

[@brokenicry]

51:55 WOULD you please make a follow-up video regarding what you mentioned at 51:55 ?? Especially different versions of the footprint? I have noticed that every time I download a part from the manufacturer part Search, the footprint comes with 3 different versions. Is it the same thing?

[@RobertFeranec]

Thank you BrokenICry. It is on my list - still testing different methods to find out the best way to do it.

[@abdulfattahalhousein9634]

Great

[@madGambol]

What happens to the supplier info in the database for that part? How does it get updated? Thanks for the excellent video!! Chris

[@RobertFeranec]

Thank you Chris. What minute in the video are you referring to? Supplier info is uploaded when you import the parameters from manufacturer part search.

[@madGambol]

@@RobertFeranec At about 28:52 you talk about the imported parameters, and that includes the stock and pricing columns, which change over time. Those values are entered into the mysql DB, right? What happens to those values when the BOM is created? Are those refreshed from the current values the supplier has? When I'm trying to assemble the production files, I try to select vendors that have stock so that the fabricator won't ask me if they can substitute some other part. Another issue I see is that setting the field width to 45 causes the URL values to be truncated. Is there a penalty for using "tinytext" versus varchar(255) ? Thanks! Chris

[@madGambol]

Is updating the stock and price something that can be done via the "triggers" you mentioned at the end? This was a great video. Thanks again! Chris

[@RobertFeranec]

@@madGambol Yes, values are refreshed every time BOM is generated. PS: You can use varchar(255), I also had to increase it. PSS: I do not think you can easily refresh the values through triggers - altium does it.

[@DanielPereiraCarvalho]

Is there a way to associate more than one footprint to a single componente? Thanks

[@RobertFeranec]

I believe you can use Footprint Ref n (see www.altium.com/documentation/17.0/display/ADES/((Working+with+Database+Libraries))_AD )

[@tranucchinh3743]

Thanks Robert! As far as I understand, you will store component's parametters on the AWS cloud; Symbols and Footprints are on the github. When working in a team, members clone Symbols and Footprints about their local server, link Altium to the cloud library via odbc driver, and can use and create new components. Then update back to cloud and Github? Is that true? Can you make a tutorial video with 2 members who can share the db library, create new and update more components on it? Thank you very much!

[@RobertFeranec]

Yes, that is correct. I was planning to make the video - but we have currently moved to Altium 365 and I am testing that as a solution for collaboration. After couple of months of using it I would like to than make a video about it ... and maybe add some thoughts about advantages / disadvantages between these two solutions.

[@tranucchinh3743]

@@RobertFeranec Let me ask a little more. In case I want to use SVNDbLib, I have to use an external SVN client and server, such as TortoiseSVN to replace the AWS cloud right? I really still wonder what to do? And still use ODBC driver to map database record to component parameter / model and Specifying the link to the SVN repository in which the symbol and model libraries are stored?

[@RobertFeranec]

@@tranucchinh3743 AWS cloud is used to store Database. You would need to use something else for TortoiseSVN (your own server or an online service)

[@tranucchinh3743]

@@RobertFeranec Can you show me how to use SVNDbLibrary with TortoiseSVN? Can you let me make friends with facebook to discuss more about this?

[@RobertFeranec]

@@tranucchinh3743 I do not use SVN.

[@MrFreeElectron]

how can we store the symbols and the footprtins on AWS ? It's all good to have the dblib there , but you can;t place the parts unless you have the schlib and pcblib !

[@ale210]

Hi Robert, I very apprecieated your video, very useful and well explained. However, in most of case, you cannot create a database ,cause you already have a "work library", so don't have permissions to modify any fields or add it. Can you explain how to, with a database, adapt the parameters to the altium library? For example in my work every component it has a intern part number, so i want create a component with these internal part number. hope you understand me, sorry for my english.

[@RobertFeranec]

I think, you can import existing library into database library. I have not tried that yet, but I think I saw it in menu. Import should add new columns, including intern part numbers. PS: You can always add your own columns into the database library if you need to add some additional information (e.g. your part number).

[@emanuelaschenbrenner3285]

Please make the follow up video!

[@abdullahcanbaz6429]

Which windows operating system do you recommend for Altium Designer win7,8,10

[@RobertFeranec]

I use Win 7 and generally do not have problems with Altium (or at least not more than usual). I do not know if there are differences when using other Windows, I have not tried it. Maybe someone else knows?

[@abdullahcanbaz6429]

@@RobertFeranec Thank you for teaching us PCB. I will continue to follow you. :)

[@konturgestalter]

Hello Robert, I followed the tutorial closely, but when I try to import the resistor as you do, I get the following error: "Row cannot be located for updating. Some values may have been changed since it was last read". I have not found a fix yet, do you know what the reason could be?

[@patrickmagee774]

I'm getting the same, were you able to fins a solution?

[@konturgestalter]

@@patrickmagee774 Nopppeee... I decided not to use a database, solution by ignoring it :)

[@meandyna1161]

I have the same problem as you I don't know what to do

[@chaochang1305]

When I chose "select database type",AD got stucked......maybe another bug

[@amitteke6224]

Hello sir...First of all thank you for sharing such a useful video. I am first time Altium DBLIB user. While I am using Microsoft Access dblib to import component it import all parameter. After importing few component, for new component it show below error. Error - Record too large Is their any way to limit/minimise import parameter in Altium Access dblib.

[@DrAkhtarAli08]

Hi Robert... I need help if you worked on PCDL

[@pick565]

at 20:00 when i tried to connect the Altium with the odbc i got the error the drop list was empty. When manually entered the data source name and tested the connection i got the following error. [Microsoft datalink error TEST connection failed The specified DSN contains an architecture mismatch between the drive and the application.] any fix for this error. i am using the local database my sql.

[@anthonyphan4036]

I had a similar error. Turns out I had a firewall rule preventing Altium from connecting to the SQL database via the ODBC Connection.

[@dmitry771]

Maybe it will be interesting for someone. It's possible to use simple text CSV files as a data base. I can give you a link to the tutorial, but it's in Russian.

[@efox29]

it would be interesting...

[@dmitry771]

@@efox29 we.easyelectronics.ru/CADSoft/korporativnaya-biblioteka-komponentov-dlya-altium-designer-svoimi-rukami.html

[@dmitry771]

The short story is that this guy uses free ODBC driver from Microsoft. You can configure the driver to use CSV files, one file - one DB table. But it's better to read the full article. Just feed it to the Google translator. If something is unclear, you can ask me.

[@nickagiann]

I am experiencing some issues with my DbLib library. After creating the database and populating it with various components I see everything has worked OK because in the components panel I see all properties, symbols and footprints I have put in. But then weirdly enough when I import any of those components in the Schematic none of those properties comes with. In the properties panel of the component all is empty. It looks like only the symbol has come with no other information. Any idea anyone? Has anyone seen this again?

[@RobertFeranec]

Where are you looking? There are some switches what you may need to enable to load parameters from DB - e.g. when you are creating BOM or in ActiveBOM etc. By default it should work when inserting component from library, but maybe there is something similar in preferences(?)

[@nickagiann]

@@RobertFeranec I am looking at the properties panel, right after inserting a component from the library. I haven't gotten as far as BOM creation! 🙂 But I'll try look for such a switch, if there is one. But you didn't have to do sth like this yourself, did you?

[@RobertFeranec]

@@nickagiann for me it just worked oki (by default, no special settings). Try to check also all network/communications settings in preferences if you do not have something disabled.

[@engineer897]

Hello, that's video is so usefull thank u so much but isnot Aws free anymore?

[@pick565]

Will it work in altium 16

[@RobertFeranec]

Hmm, I have not tried it, but it could.

[@chinphamxuan]

Dear Robert, It seems after 12 months using RDS for free, we have to pay monthly cost as shown 05:42

[@abdulfattahalhousein9634]

Haw can i get Altium to install it in my computer for free?

[@dmitry771]

Torrents?

[@abdulfattahalhousein9634]

I didnot understand you

[@richard-sim]

I found the Altium Bug Crunch entry (from May 2013...) for the connection-string bug - it'd be great if everyone using database libraries would click Vote to push the bugs visibility up: bugcrunch.live.altium.com/#Bug/2931 Voting is the only way this will ever get fixed!

[@davisgrier5162]

Looks like AWS is only free for 12 months. That's a bummer.

[@RobertFeranec]

Yes, it is free only for 12 months, but even after that it is not expensive. The cheapest option is like 12USD / month - that is a very good price, especially because you do not need to worry about crashing your server or running multiple haddrives or doing backups - in aws everything is done automatically the way you set it up and you do not need to care about hardware. It is a huge help.

[@abdullahcanbaz6429]

Please Subtitle Robert Feranec :(

[@RobertFeranec]

I would love to create subtitles for all my videos and in all language. I try my best to add subtitles to the most popular videos, unfortunately it is not possible for me to add subtitles to all videos. If anyone would like to help, please let me know.

[@abdullahcanbaz6429]

@@RobertFeranec If anyone is interested, I try to redirect

[@user-rk1kz3jp8c]

Hello~ Do you have msn to add friends? Can you ask altium designer questions? Thank you

[@haijiazhu3148]

Who the hell will hit dislike?????

[@JRabba1995]

Hello Robert. Thanks for all your videos. You are the GOAT. After I link Altium to the database I can easily add new components but when I try to delete them I get this error message: "row cannot be located for updating some values may have been changed since it was last read". I can't figure out what the problem is. When I go the MySQL Workbench I can see the added component with the following name "N敷⁃潭灯湥湴". Could these behaviors be related? Can you help me? please Thanks again, Robert

[@OakCountyPoliceDpt]

Were you able to resolve this issue? I have the same thing happening to me.

[@JRabba1995]

@@OakCountyPoliceDpt no. I have not. Please let me know if you find a solution

[@OakCountyPoliceDpt]

@@JRabba1995 So - it looks like the Altium -> MySQL update is dropping the leading zeros from the UTF16 characters E.g. New Component - > 004E 0065 0077 0020 0043 006F 006D 0070 006F 006E 0065 006E 0074 N敷⁃潭灯湥湴 - > 004E 6577 2043 6F6D 706F 6E65 6E74 I dont know why.... but I think that is the issue. Looking into the ODBC configuration or Charset/Collation settings now.

[@OakCountyPoliceDpt]

@@JRabba1995 I have resolved the issue - Switching the structure Table Charset to be UTF8 and changing the Primary Key datatype to be VARCHAR(255) fixed everything for me.

[@chaochang1305]

I WOULD LOVE TO SEE THE FOLLOW UP VIDEO. Thanks for all your guidance Robert :)

[@forresterickson6225]

Robert, Wow some heavy lifting on this one. At 49:45 you selected "Override Library Primitive". It is not clear what is going on here. Yes, the effect is that the comment becomes visible, but I do not understand what was going on "under the hood". What was the primitive that was being over ridden? What does override mean, ie who is overriding what where? What is the scope of this overriding? For example, is the scope this project? Also, unless I am missing something, your two parts have very different parameter list. Will this not cause problem generating BOM with the default spreadsheet template you provided in your LED tutorial series? ( I asked this same question on another library video an hour ago or so.) It would be great if you should show how (or provide a link to a video on how) to back up the database you just made as it is now very valuable (you would not want to have to recreate it.) Thanks again.