Data Xtractor 2.1  數據提取器
DataXtractor提供數據提取功能，可以幫助用戶在軟件界面直接提取你需要的數據，這款軟件可以連接到多個數據庫，可以直接在SQLite、Firebird、MicrosoftSOLServer、MicrosoftAccess等數據庫提取你需要的數據，軟件提供遠程連接功能，輸入登錄數據庫的賬號就可以直接訪問數據庫，從而在軟件界面選擇你需要的數據導出保存，方便用戶在遠程直接獲取數據庫內容，軟件提供非常多的查詢功能，支持對數據資源查詢，支持將SQL查詢結果複製或導出為文本，圖像，PDF等。

DataXtractorcombinesVisualXtractor,QueryXtractorandModelXtractorintoonesinglestandaloneapplication.OnlyinDataXtractoryoumaydesignSQLquerieswithdatavisualizationgraphs.OnlyinDataXtractoryoumayusethevisualSQLquerybuilderforOpen-SourcedatabasessuchasMySQLorPostgreSQL,orCommercialdatabaseslikeMicrosoftSQLServerorOracle.

Features:
AllModelXtractorFeatures
AllQueryXtractorFeatures
AllVisualXtractorFeatures
LookupTableDatafromERModel:right-clickonatableshapeinanyERmodeldiagramandselectLookupTableData,orViewTableDatatoopenanewtab
VisualQueryBuilderwithCharts:inlineandregularchartssimplyextendthebasicQueryXtractorvisualbuilder,soyoucannotonlydesigncomplexqueries,butalsogeneratenicechartsfromtheirresultdata
QueryBuilderforAnyDatabase:onlyDataXtractorcanusethevisualquerybuildertogenerateSQLandrunqueriesfromOpen-SourceandCommercialdatabases(MySQL,PostgreSQL,SQLServer,Oracleetc),forasmallmonthlyfee
All-in-OneApplication:everythingfromVisual,QueryandModelXtractorcanbealsofoundinDataXtractor,andseparateXtractorapplicationcannotbeusedsimultaneously

DataXtractor=Model+Query+VisualXtractor
DataXtractorcancreateandopenbothERmodeldiagrams(asinModelXtractor)anddesignedSQLqueries,withextendedvisualSQLbuilders.
UnlikeQueryXtractor,DataXtractorextendsitsvisualSQLquerybuildertoincludetheInlineChartandChartbuilders.YoucandesigncomplexSQLqueriesandassigndirectlydatavisualizationeffects–inlineandregularcharts–totheresultcolumns.

DesignSQLQueriesforOpen-SourceandCommercialDatabases
AllourproductsareFREEforwhatwecallFeatureddatabases:SQLite,Firebird,MicrosoftSQLServerCEandMicrosoftAccess.OnesinglerestrictionappliestoqueriesforOpen-SourceandCommercialdatabases:youneedamonthly(annualypaid)subscriptiontogetandruntheSQLgeneratedfromqueriesdesignedwithourSQLbuilders.

LookupTableData
OnlyDataXtractorallowsyoutoinstantlycheckthedatastoredinatableyouvisualizeinanentity-relationshipmodeldiagram.Thisalsoappliestoviewsorqueries.Justright-clickonashapeheaderandselectLookupTableData.ViewTableDatawillvisualizethesamedatainanewtab.

ModelXtractor–YourDataModelingInspector
Reverse-engineerexistingdatabasemodels.TraditionalandenhancedERdatamodelsfordozensofrelationaldatabaseplatforms,includingSQLServer,Oracle,MySQL,PostgreSQL,AzureandAmazonRedshift,SQLiteandFirebird.

QueryXtractor–VisualSQLQueryBuilder/Generator/Runner
Createsimpletocomplexread-onlySQLSELECTquerieswithoutwritingonesinglelineofSQL.NopriorSQLknowledgenecessary.UsethisproductivitytooltoproducecomplexSQLSELECTquerieswithinseconds,drill-downonresultsthroughaggregationsandrelationships,useouremulatedqueriestogetyourdatafast.

GenericQueryEmulator–Pivot/CrossTablesforanyPlatform
Weemulate,usingSQL,manyfeatureswithnativesupportonsomedatabasesystems,butmissingonotherplatforms:pivot/crosstabs,groupingsets(withcube/rollup),intersectandexcept,sequencegenerator,datatypefunctionsetc.Forinstance,thisishowapivot/crosstabqueryisemulatedonMariaDB.ColumnheadervaluesareautomaticallydetectedandwetransparentlyaddrelativelycomplexSUMentriesingeneratedSQL.

What'sNew:
officialsitedoesnotprovideanyinfoaboutchangesinthisversion.

Homepage
https://data-xtractor.com/data-xtractor/