span8
斯潘4
As announced by Google on December 11,2018, Google Fusion Tables and the Fusion Tables API will be turned off on December 3,2019。Some users may start to see errors in August 2019.Fusion Tables support will be removed from FME after the service has been shut down.关于使用FME从Google Fusion表中迁移数据的方法,see the blog post 7+ Google Fusion Tables Alternatives.
FME服务器可以利用外部数据库触发器实时响应数据库事件。This allows you to push out data from your database into applications using FME Server in real-time as features in the database are modified.在本文中,我们将向您展示如何设置SQL Server和FME Server,以便在单个调用中响应多个功能编辑。Bulk insert is useful when you anticipate a large number of edits being made so that FME Server does not get tied up with multiple calls.For smaller numbers of edits,您可以设置数据库触发器,以便在每次功能编辑后调用FME服务器。这在以下文章中描述:Single edits SQL Server: Push data from the database to an application in real-time
NOTE: This example was created to demonstrate different interaction possibilities between FME Server and SQL Server.本文包含几个必须为特定环境定制的代码段。
本教程通过FME桌面和FME服务器2017.0和SQL Server 2016进行了测试。
在本例中,我们使用一个简单的Web界面,该界面调用FME服务器,以在SQL Server数据库中上载数据和记录更新。用户从Web界面运行演示时的事件顺序如下:
此示例演示如何设置可以使用HTTP请求在FME服务器上调用工作区的SQL Server触发器。We recommend you read the scripts carefully to you ensure you have fully tailored them to your database environment.
我们需要创建两个表(一个用于存储实际数据,and a temporary one to cache the IDs of newly modified rows in our database) and set triggers for inserts,updates,and deletes on all rows.We also need to create a procedure that concatenates all information from the temporary table into a string that can be appended to a URL,以及允许数据库使用HTTP访问FME服务器的过程。This can be done by running Create_Bulk_Table_and_Triggers.sql.需要对SQL脚本进行一些修改,如注释和以下图像中所示。
...
...
本演示涉及一个模板和一个工作区:sqlserver_bulk_loader.fmwt和sqlserver_bulk_logger.fmw,which are included in the zip file attached above.
Open the templatesqlserver_bulk_loader.fmwt工作区。
编辑SQL Server编写器参数以匹配您自己的数据库凭据。
将工作区发布到名为触发器的新存储库中的FME服务器。
Next,打开sqlserver_bulk_logger.fmw工作区。
编辑SQL Server编写器参数以匹配您自己的数据库凭据。
编辑FeatureReader Transformer以匹配您自己的数据库凭据。
最后,GoogleFusion表编写器有两个私有参数,需要从导航器窗口配置。
Double click each parameter and enter your Gmail account username and password respectively.
Once everything is configured,将工作区发布到触发器存储库中的FME服务器。
Make sure the fmeguest role has Read and Run permissions on the trigger repository.这可以通过以管理员用户身份登录到FME服务器并单击“管理员”下左侧边栏上的“安全性”来设置。单击角色,and selecting fmeguest.在许可下,expand the Repositories section and for the trigger repository select Read and Run if they are not already selected.
Run the sqlserver_bulk_logger workspace once either from FME Server or FME Desktop to create the Google Fusion Table (to view the table,log in to the Gmail account specified and the table should appear under the ‘Drive' Tab) make note of the table's URL for the next step.
将zip文件中包含的“web”文件夹的全部内容复制到Web服务器。然后编辑index.html文件的内容,包括FME服务器的名称和Google Fusion表的URL。
Once this is complete,在Web浏览器中打开index.html并运行其中一个选项。This should modify the data in the SQL Server Database triggering information to be written to the Google Fusion Table.您可以单击网页上的链接打开表格。
批量编辑PostgreSQL:将数据从数据库实时推送到应用程序
Single edits SQL Server: Push data from the database to an application in real-time
收到邮件,Part 1: Setting up a topic and an email address (2015)
Data Upload,验证,and Real-time Display
HTTP POST Requests to FME Server from Node.js
Streaming features from PostGIS to FME using WebSockets
从Postgis到Amazon SQS的流化特性——FME中的流程
Bulk Edits Oracle: Push data from your database to your application in real-time
?2019安全亚搏在线软件公司|Legal