Sometimes we get queries about whether our plugin may slow down FileMaker Pro starting and we like to show you various ways the startup of FileMaker may be slower than usual:
Certificates
FileMaker tries to verify the code signature of the plugin via Windows API calls. Windows itself wants to refresh the certificates every week and does a network query to do so. This fails and after a few seconds, it gives up and continues doing the verify with the certificates on disk. If you turn the Wifi/LAN off and start FileMaker offline, it may be much faster to do so. In that case you may want to check firewall to let Windows contact it's update server to refresh the certificates once. Then the start time should be back to normal for a while.
(more)
In the past we may have connected a FileMaker solution to push data to a web server with a MySQL database. But nowadays, we prefer MongoDB for a lot of things. No hassle dealing with defining the schema upfront and enjoying a lot of built-in features like audit logs and scaling via a cluster.
With MongoDB we can setup a cluster and link a few servers together as a cluster. Within the cluster the MongoDB servers synchronize themselves automatically eventually. You may connect for example a server in America with one in Europe and one in Asia. This distributes the load to this servers and makes the whole access more responsive. If needed, we can later add more servers. Like for USA have a server in California, in Texas and one in New York to distribute load within the USA better. The cluster can grow as you need more servers to handle the load. You may even add a local on-premise server to that cluster, so you have a local copy of the MongoDB and work when your office is offline.
Let us draw this for you:
Once you have the cluster, you could connect to it. We may have several web servers to show a website and have it access the MongoDB cluster to query the data. Since the web servers are distributed to be close to the customer, they can connect to the cluster and end up connecting to the closest server. That may show data on the website.
(more)
While we have our advanced RegEx functions in MBS FileMaker Plugin using RegEx.Compile and RegEx.Execute, we got a set of easier functions:
RegEx.Match
This function can simply tell you whether there is a match, e.g. when you like to check if some text is contained in a piece of text.
You can play with the data viewer and just evaluate it. e.g.
MBS( "RegEx.Match"; "H(.*)o"; "Hello")
Or use it to check if for example a text is a number by using a pattern like this:
MBS( "RegEx.Match"; "^(\d+)$"; "12345")
The ^ means the beginning of the line (if multi line is enabled) or beginning of the input text. The $ is the end of the line (in multi line) or the end of input in the default mode with single line.
Of course you can pass in flags. You can pass compilation and execution flags. A compiler flag may be something like Caseless vs. CaseSensitive, Multiline or SingleLine, Greedy or Ungreedy, or something for end of line like NewlineAny. Here is a sample where we ask for case insensitive comparison:
MBS( "RegEx.Match"; "H(.*)o"; "hello"; "caseless")
(more)
Since we added the search box for the relationship graph for Windows, a lot has improved. We fixed bugs and added more functionality, so checkout the version as in version 13.1 of the MBS Plugin for both FileMaker Pro and Claris Pro:
As you may notice the look changed a bit and it is no longer a text field, but a combo box, so you can popup the control and see the choices. We populate the choices when the dialog opens, so if you just added a new table, it doesn't yet show up. But next time you open the window, it should be in the list:
We hide the field, if you move to another tab. And when we create the field, we generate two hotkeys: Control-F and Control-G. You can press Control-F to move focus to the search field. Type something and press return. Then you can press Control-G to search again.
(more)
Check out the FMTraining.tv website. Richard Carlton and his team do a daily free live stream about FileMaker to watch.
A few days ago Christian Schmitz from Monkeybread Software joined a live episode to talk a bit about the MBS FileMaker Plugin. Watch it on YouTube.
We talk about what is new in MBS FileMaker Plugin 13.1 including MongoDB, WindowsOCR, CURL, new checkboxes in preferences and more.
(more)
In this article we want to introduce you the new functions from the MBS FileMaker Plugin in version 13.1.
Archive
With the new functions of the Archive component you can easily create your own archives. First, you create a new archive with the Archive.Create function. In this function you define the format in which your archive should be written. The following formats are available: 7zip, ar, arbsd, argnu, arsvr4, bsdtar, cd9660, cpio, gnutar, iso, iso9660, mtree, mtree-classic, newc, odc, oldtar, pax, paxr, posix, raw, rpax, shar, shardump, ustar, v7tar, v7, warc, xar and zip. Then we have to choose a filter that fits the format. Optionally, we can then specify a storage location with a file path. You can pass specific information about a format in further parameters and specify a password for the archive, which must be entered by the user when opening it. You can then use the Archive.AddFile, Archive.AddText and Archive.AddContainer functions to add the appropriate files to this archive. When you are done, close with Archive.Close. If we expect a container value back it will be in the output of this function. For a file that has been saved on disk, we get an OK. Here we see a script in which first the zip archive is created and then a text file, a file from a container and two files from a folder are added to the archive. After that the archive is closed again and stored on the desktop.
Set Variable [ $Path ; Value: MBS("Path.AddPathComponent"; MBS("Folders.UserDesktop"); "abc.zip") ]
Set Variable [ $r ; Value: MBS("Archive.Create"; "zip"; "deflate"; $Path; ""; "Hello") ]
Set Variable [ $r ; Value: MBS( "Archive.AddText"; "Hello World"; "UTF-8"; "Hello.txt" ) ]
Set Variable [ $r ; Value: MBS( "Archive.AddContainer"; Tabelle::Container ; "Image.png" ) ]
Set Variable [ $r ; Value: MBS("Archive.AddFile"; "a.png¶b.pdf"; MBS("Path.AddPathComponent"; MBS("Folders.UserDesktop"); "testA")) ]
Set Variable [ $r ; Value: MBS("Archive.Close") ]
MongoDB
The new functions from the MongoDB component should make your work with Mongo DB much easier. We added aggregate functions for you to query data by applying a filter, sorting rules and grouping either to the whole database or only to a specific collection. Also, we can query the TLS status of the database to see if it is encrypted. With the function MongoDB.GetOptions we can query the options from the URL as a JSON document.
(more)
Noch einen Monat Zeit für den Frühbucherrabatt.
Vom 21. bis 23. Juni 2023 findet die zwölfte deutschsprachige
FileMaker Konferenz in Basel, Schweiz statt. Das ODELYA Hotel liegt zentral neben der Baseler Altstadt und ist fußläufig vom Bahnhof erreichbar, so dass sich die Anreise per Bahn empfiehlt. FileMaker Anwender und Entwickler können ihre Teilnahme seit dem 1. Januar 2023
buchen.
FileMaker Konferenz.com
Viele Konferenzen haben eine Mindestteilnehmerzahl und ein Absagedatum. In der Regel gibt es mit dem Hotel eine Vereinbarung für ein kostenloses Stornieren bis zu einem Datum. Wenn sich bis zu dem bestimmten Datum zu wenig Leute anmelden, wird die Konferenz abgesagt ohne dass der Organisator große Verluste macht. In den letzen Jahren kam das ja durchaus mal vor. Für die Teilnehmer ist der Frühbucherrabatt eine Möglichkeit ein paar Euro zu sparen und auch beim Hotelzimmer eine günstige Rate zu bekommen.
Möchten Sie Sponsor oder Sprecher werden?
Aktuell sucht der FMK Verein Vorschläge für interessante Vorträge.
Die Veranstalter vom Verein FM Konferenz erwarten auch 2023 rund 150 Entwickler, Anwender, IT-Fachleute und Entscheidungsträger aus Wirtschaft, Bildung und Verwaltung. Rund um über 25 Fachvorträge und Workshops wird es viel Zeit zum Vernetzen in den gemeinsamen Pausen und beim Abendprogramm geben.
Monkeybread Software ist als Platin Sponsor mit Stand und Session vor Ort. Bitte kommen Sie mit Ihren Fragen vorbei!
Nickenich, Germany - (March 7th, 2023) -- MonkeyBread Software today is pleased to announce MBS FileMaker Plugin 13.1 for Claris FileMaker for macOS, iOS, Linux and Windows, the latest update to their product that is easily the most powerful plugin currently available for Claris FileMaker produce line. As the leading database management solution for Windows, macOS, iOS and the web, the Claris FileMaker Pro Integrated Development Environment supports a plugin architecture that can easily extend the feature set of the application. MBS FileMaker Plugin 13.1 has been updated and now includes over 7000 different functions, and the versatile plugin has gained more new functions:
Our new WindowsOCR functions allow you to use the built-in OCR engine in Windows 10 or newer. You can pick a language for initialization, load an image from file or container and perform OCR recognition on it. The result can be requested either as text or as JSON with individual lines and words separated. The Vision.RecognizeText function is adapted to use the same OCR technique on Windows.
We continue on the MongoDB functions and add aggregate functions to query data applying a filter, sort rules and grouping on either the whole database or only a given collection. You can run custom commands on the database and query TLS status.
The Archive functions got new functions to create a new archive. Then you can call functions to add text, container values or files to the archive before you store it on disk or in a container.
We rewrote the WindowsUserNotification functions to use better APIs from Windows. We added a couple new properties to set to allow notification grouping, set priority and expiration on reboot.
The WebKit JavaScript engine can now be used on Windows and Linux in addition to MacOS and iOS. This includes using it server side for evaluating JavaScript. For Windows and Linux you have to use JavaScript.LoadLibrary function to load your copy of the JavaScriptCore library.
For WebView functions we implemented the WebView.AllCookies function for Windows. You can use it to query the current cookies set in the web viewer and use them for CURL functions. We implemented WebView.PrintToFile for Windows to save a website as PDF file.
The XL functions for reading and writing Excel documents got updated to include 45 new functions for handling form controls. Other functions can check for write protection, handle default row height and active cell or selection range.
We added regular expressions to our script search in the Script Workspace. If enabled via preferences dialog or SyntaxColoring.ScriptSearchBox.SetRegEx function, you can use regular expressions in your search strings. Multiple search terms are still separated by space character.
For iOS we got functions to allow you to capture swipe gestures with iOSApp.AddSwipeGestureRecognizer function. You can set a script to trigger when the plugin detects a swipe gesture and then react by switching layouts.
DynaPDF added support for writing PDF/UA-1 files. The new DynaPDF.CreateStructureTreeEx function can be used to create the required tag structures for your PDF documents. The DynaPDF.ChangeNamedDest function can now rename named destinations. And with DynaPDF.SaveAndSignFileExt1 and DynaPDF.SaveAndSignFileExt2 functions, you can sign a PDF using an external PKCS7 signature provider.
For Windows we updated Clipboard functions for PDF handling on Windows as well as the Container.ReadImage functions to read HEIF files. The relationship search box on Windows is now a combobox with a popup containing table names. The Process.SetDllDirectory function can help on Windows to load various DLLs from a given folder.
Finally we updated the CURL library to version 7.88.1, DynaPDF to 4.0.72.208, LCMS2 to 2.15, LibXL to 4.1, libxml to 2.10.3, openssl to 1.1.1t, SQLite to 3.41.0, and tiff library to version 4.5.0.
See release notes for a complete list of changes.
7. März 2023 - Monkeybread Software veröffentlicht heute das MBS FileMaker Plugin für Claris FileMaker in Version 13.1, mit inzwischen über 7000 Funktionen eines der größten FileMaker Plugins überhaupt. Hier einige der Neuerungen:
Unsere neuen WindowsOCR-Funktionen ermöglichen es Ihnen, die integrierte OCR-Engine in Windows 10 oder neuer zu verwenden. Sie können eine Sprache für die Initialisierung wählen, ein Bild aus einer Datei oder einem Container laden und eine OCR-Erkennung darauf durchführen. Das Ergebnis kann entweder als Text oder als JSON ausgeben werden. Im JSON sind dann die einzelnen Zeilen und Wörtern getrennt aufgelistet mit Koordinaten. Die Funktion Vision.RecognizeText benutzt unter Windows intern die gleichen Funktionen.
Wir erweitern unsere MongoDB-Funktionen und fügen Aggregatfunktionen hinzu, um Daten abzufragen, indem wir einen Filter, Sortierregeln und Gruppierungen entweder auf die gesamte Datenbank oder nur auf eine bestimmte Sammlung anwenden. Sie können benutzerdefinierte Befehle in der Datenbank ausführen und den TLS-Status abfragen.
Die Archivfunktionen haben neue Funktionen zum Erstellen eines neuen Archivs erhalten. Anschließend können Sie Funktionen aufrufen, um dem Archiv Text, Containerwerte oder Dateien hinzuzufügen, bevor Sie es auf der Festplatte oder in einem Container speichern.
Wir haben die WindowsUserNotification-Funktionen umgeschrieben, um bessere APIs von Windows zu verwenden. Wir haben ein paar neue Eigenschaften hinzugefügt, um die Gruppierung von Benachrichtigungen zu ermöglichen, die Priorität festzulegen und den Ablauf bei Neustart zu bestimmen.
Die WebKit-JavaScript-Engine kann jetzt nicht nur unter MacOS und iOS, sondern auch unter Windows und Linux verwendet werden. Dies schließt die serverseitige Verwendung für die Auswertung von JavaScript ein. Für Windows und Linux müssen Sie die Funktion JavaScript.LoadLibrary verwenden, um Ihre Kopie der JavaScriptCore-Bibliothek zu laden.
Für WebView-Funktionen haben wir die Funktion WebView.AllCookies für Windows implementiert. Mit ihr können Sie die aktuell im WebViewer gesetzten Cookies abfragen und für CURL-Funktionen verwenden. Für Windows haben wir WebView.PrintToFile implementiert, um eine Website als PDF-Datei zu speichern.
Die XL-Funktionen zum Lesen und Schreiben von Excel-Dokumenten wurden um 45 neue Funktionen zum Umgang mit Formularsteuerelementen erweitert. Andere Funktionen können den Schreibschutz prüfen, die Standardzeilenhöhe und die aktive Zelle oder den Auswahlbereich verändern.
Wir haben reguläre Ausdrücke zur Skriptsuche im Skriptarbeitsbereich hinzugefügt. Wenn sie über den Einstellungsdialog oder die Funktion SyntaxColoring.ScriptSearchBox.SetRegEx aktiviert ist, können Sie reguläre Ausdrücke in Ihren Suchstrings verwenden. Mehrere Suchbegriffe werden weiterhin durch ein Leerzeichen getrennt.
Für iOS gibt es die iOSApp.AddSwipeGestureRecognizer um auf Wischgesten zu reagieren. Sie können ein Skript starten, wenn das Plugin eine Wischgeste erkennt und entsprechend reagieren indem Sie zum Beispiel das Layout wechseln.
DynaPDF unterstützt nun auch das Schreiben von PDF/UA-1 Dateien. Mit der neuen Funktion DynaPDF.CreateStructureTreeEx können Sie die benötigten Tag-Strukturen für Ihre PDF-Dokumente erzeugen. Die Funktion DynaPDF.ChangeNamedDest kann nun benannte Ziele umbenennen. Und mit den Funktionen DynaPDF.SaveAndSignFileExt1 und DynaPDF.SaveAndSignFileExt2 können Sie ein PDF mit einem externen PKCS7 Signaturanbieter signieren.
Für Windows wurden die Funktionen der Zwischenablage für die PDF-Verarbeitung unter Windows sowie die Funktionen von Container.ReadImage zum Lesen von HEIF-Dateien aktualisiert. Das Beziehungssuchfeld unter Windows ist jetzt eine Combobox mit einem Popup, das Tabellennamen enthält. Die Funktion Process.SetDllDirectory kann unter Windows helfen, verschiedene DLLs aus einem bestimmten Ordner zu laden.
Schließlich haben wir die CURL-Bibliothek auf Version 7.88.1, DynaPDF auf 4.0.72.208, LCMS2 auf 2.15, LibXL auf 4.1, libxml auf 2.10.3, openssl auf 1.1.1t, SQLite auf 3.41.0 und die tiff-Bibliothek auf Version 4.5.0 aktualisiert.
Alle Änderungen in den Release Notes.
A client asked about uploading via SFTP and using rename command with MBS FileMaker Plugin. There is a trick to use quote commands to rename the file when the uploaded finished. We like to avoid having a half uploaded file, so we upload to a temporary file first and then rename it.
Take a look on this script:
Set Variable [ $curl ; Value: MBS("CURL.New") ]
Set Variable [ $result ; Value: MBS( "CURL.SetOptionURL"; $curl; CURL Test::URL & "temp.jpg") ]
# login via password
Set Variable [ $result ; Value: MBS( "CURL.SetOptionPassword"; $curl; CURL Test::Password) ]
Set Variable [ $result ; Value: MBS( "CURL.SetOptionUsername"; $curl; CURL Test::Name) ]
Set Variable [ $result ; Value: MBS( "CURL.SetOptionSSHAuthTypes"; $curl; 2+8 ) ]
# data to upload from container field
Set Variable [ $result ; Value: MBS("CURL.SetOptionUpload"; $curl; 1) ]
Set Variable [ $result ; Value: MBS("CURL.SetInputFile"; $curl; CURL Test::Image) ]
# Require TLS 1.2 for FTP over SSL:
Set Variable [ $result ; Value: MBS( "CURL.SetOptionUseSSL"; $curl; 3 ) ]
Set Variable [ $result ; Value: MBS( "CURL.SetOptionSSLVersion"; $curl; 6 ) ]
# download existing file, rename after upload
Set Variable [ $result ; Value: MBS( "CURL.SetOptionPostQuote"; $curl; "*rm image.jpg"; "rename temp.jpg image.jpg" ) ]
# see progress in debug messages
Set Variable [ $result ; Value: MBS( "CURL.SetDebugWithProgress"; $curl; 1 ) ]
# perform it
Set Field [ CURL Test::Result ; MBS("CURL.Perform"; $curl) ]
Set Field [ CURL Test::debug ; MBS("CURL.GetDebugMessages"; $curl) ]
Set Field [ CURL Test::Output ; MBS("CURL.GetResultAsText"; $curl) ]
Set Variable [ $result ; Value: MBS("CURL.Release"; $curl) ]
(more)
You may know our JavaScriptWebKit functions for macOS and iOS. But with the upcoming 13.1 release, you can use those functions on Windows and Linux, too. It's up to you to provide the library, so we go through this step by step for Linux. Here is the screenshot with the trace output on Linux:
You should have a recent FileMaker Server installed on Linux with Ubuntu in a recent version. Please open a terminal connection either by doing so on the server directly or via ssh connection.
(more)
New in this prerelease of version 13.1 of the
MBS FileMaker Plugin:
- Changed plugin to ignore Registration calls with older keys if a newer license was already set to avoid complaining dialogs when opening older solutions.
- Added PKCS12.SignData function.
- Updated LCMS2 library to version 2.15.
- Changed SQL functions to log SQL statements when trace is active.
- Applied SQLAPI patch for Oracle fix in memory leak.
- Fixed ScreenshotRect, Container.Screenshot and WebView.Screenshot for Windows to better use right DPI for high DPI screens.
- Added Process.GetDllDirectory and Process.SetDllDirectory functions.
- Fixed a crash in trace function.
Download at
monkeybreadsoftware.com/filemaker/files/Prerelease/, in
DropBox folder or ask for being added to the DropBox shared folder.
Recently we got asked what we can do for emailing in MBS FileMaker Plugin and MBS Xojo CURL Plugin. While we recommend not to try and replicate a full Mail client, you can do a lot with our plugins and so let us sum up what we can do:
SMTP
We provide CURL functions and SendMail functions to send emails with more options than what is built-in to FileMaker.
Send Email
Our plugin can send emails via SMTP protocol.
Port is 25 by default, but alternatively you can use port 587 if a firewall blocks port 25. Or for smtps:// protocol we use port 465.
When you send an email, you retain the protocol from curl, so you can see what happens. This may show errors like invalid credentials, hitting the email size limit and on the end an OK message from the server for accepting the email.
(more)
New in this prerelease of version 13.1 of the
MBS FileMaker Plugin:
- Updated DynaPDF to version 4.0.72.208.
- Changed SQL functions to log SQL statements when trace is active.
- Added flag 32 for Text.TextToHTML function to use paragraphs.
- Adjusted various internals for future FileMaker versions.
Download at
monkeybreadsoftware.com/filemaker/files/Prerelease/, in
DropBox folder or ask for being added to the DropBox shared folder.
For 13.1 we get new Archive functions to build a zip archive on the fly. One of the use of deprecated ZipFile functions was to assemble an archive in memory from various files or containers. You can now do that with our Archive.Create function. Just call it to either start an on-disk or in-memory archive using the compression format and compression filter of your choice. We usually use zip for maximum compatibly, but you can also do tar or 7zip.
Next you can add content. For that you may use Archive.AddContainer to pass a container value as variable or pass a field reference. We read the content of the container and compress it in memory. If you have existing files on disk, you can use Archive.AddFile function. Please note that you can pass a list of files with relative path parts, e.g. "Documents/email.pdf¶Documents/answer.pdf" and then the base path to find them like "C:\Users\cs\Desktop\". The relative file paths end up in the archive, so they are used when expanding the archive. If you like to add a file based of text, you can use Archive.AddText to create a text file directly in the new archive.
Let us show you an example script to zip up a few PDFs in records:
Set Variable [ $r ; Value: MBS( "Archive.Create"; "zip"; "deflate") ]
If [ MBS("IsError") ]
Show Custom Dialog [ "Failed to create zip archive." ; $r ]
Exit Script [ Text Result: ]
End If
#
Go to Record/Request/Page [ First ]
Set Variable [ $destPage ; Value: 1 ]
Loop
Set Variable [ $r ; Value: MBS( "Archive.AddContainer"; Merge PDFs::InputPDF) ]
Go to Record/Request/Page [ Next ; Exit after last: On ]
End Loop
Set Variable [ $zip ; Value: MBS( "Archive.Close"; "test.zip") ]
If [ MBS("IsError") ]
Show Custom Dialog [ "Failed to create zip archive." ; $r ]
Else
Set Field [ Merge PDFs::FinalPDF ; $zip ]
End If
As you see, we create an in-memory archive, loop over records and add PDF containers to it. Then we close the archive passing the file name and store it in a container field.
(more)
This blog has his 15th anniversary today. We hope you enjoy reading it!
If you have idea for future blog posts, please let us know.
New in this prerelease of version 13.1 of the
MBS FileMaker Plugin:
Download at
monkeybreadsoftware.com/filemaker/files/Prerelease/, in
DropBox folder or ask for being added to the DropBox shared folder.
Since their invasion of Ukraine, the Russian military has bombarded Ukraine for twelve months. As of today, both sides still belief they can win the war, so we have no negotiations. And don't be fouled: This war could be over tomorrow, when Russia decides to move out of Ukraine.
And I don't think the majority of Russian people supports this war. The average Russians has no benefit and may see their relatives and friends get conscripted and die in a war they don't want. The war is certainly not about supporting some Russian people in Ukraine, but more likely to get a land bridge to Crimea with the Russian naval base in Sevastopol. And no idea why they didn't start 20 years ago to move the base to Russian territory on the Black Sea.
The biggest change for us in all the war time is to get independent on our power supply. Shortly after the invasion started, we requested offers for photovoltaik systems. Solar cells, battery pack and a controller system to make sure we use our own power as long as possible and just use the grid as backup. And when I look around on the other houses, I see quite a lot of people coming to the same conclusion: We as a country have to reduce imports of fossil fuel and what individual houses owners can do is to first to use solar energy to heat water (to support e.g. a gas heating) and second to use photovoltaics to make our own power. Don't forget the battery to store power and use your own energy at night.
As of today our photovoltaik system is working and already produces a lot of energy. On sunny winter days about 50 kWh, which is enough to fill the battery and serve our own needs. And even on cloudy days it produces a few kWh and reduces our power purchases a lot. We ordered a battery extension already to make sure we can store more energy to avoid buying energy even further. And we ordered the extension to run the system standalone without power from the grid.
On a bigger level like state or county, we can support efforts to build wind turbines and new power cables to connect them. We may get wind turbines nearby in the next years here. Not as efficient as a the coast, but a possibility to reuse an older one from the coast, which got replaced with a better one and is paid off.
This war changes the world and in a few years, it may be over. But the world will be different and I expect Russia will not come back to its previous power and less exports as they used to. Not to mentioned that they loose a lot of people in the war or due to evading conscriptions.
Let's do our best to help the Ukraines to get back peace by kicking out the Russian Army!
New in this prerelease of version 13.1 of the
MBS FileMaker Plugin:
Download at
monkeybreadsoftware.com/filemaker/files/Prerelease/, in
DropBox folder or ask for being added to the DropBox shared folder.
You have a SQL data source and you like to get JSON from it inside FileMaker to pass that JSON on to a web services or DATA API? Or you have a SQL source and you like to move records from it to FileMaker easily? Or other direction?
Since MBS Plugin supports CubeSQL, Centura SQLBase, DB2, DuckDB, Firebird, Informix, InterBase, MariaDB, Microsoft Access, Microsoft SQL Server, MySQL, ODBC, Oracle Database Server, PostgreSQL, SQL Anywhere, SQLite, SQLCipher and Sybase as data source, we can help here. ODBC itself can of course be used for many more here.
Let us show you a script to connect to a data source by its name used in the system. This means you define in ODBC control panel on macOS, Windows or Linux to define an ODBC data source. You can use the GUI on each operation system to enter the credentials and store them there, install required driver or set whatever parameter is needed. You can alternatively check our help page for SQL.Connect to see how to put these parameters to connect into the connection string.
Once you are connected, you can run a SQL command with SQL.NewCommand and SQL.Execute and grab some records. You may put in the field names in the query if you like to define the order or only pick a few fields. If your field names contains special characters like spaces, please use \" when coding them, e.g. \"My Field\". You may rename a column with AS command inside the SQL like e.g. CityName as City. And you can always put in static data as text, date or number or even use SQL functions like concating two texts like e.g. (FirstName || ' ' || LastName) as FullName. Of course these things are depending on what database you talk to and for SQL Server you would use CONCAT() function like this: CONCAT(FirstName, ' ', LastName) as FullName.
(more)
