Importing and Exporting Knowledge
Applies to: SQL Server
You can create knowledge bases and domains directly in the Data Quality Client application, or you can import knowledge into, or export it from, a knowledge base. In the Data Quality Client application, you can use a data file for import and export operations, or an Excel file for import operations. The data file used is an encrypted file that is created by Data Quality Services (DQS) with a .dqs extension. The files created by Microsoft Excel can have an extension of .xlsx, .xls, or .csv. These operations give you more flexibility in building and sharing the knowledge that you use to perform data cleansing and matching.
You can export all the knowledge bases in your Data Quality Server to a DQS backup file (.dqsb) at once by running the DQSInstaller.exe file from the command prompt. Similarly, you can import all the knowledge bases from a DQS backup file (.dqsb) to your Data Quality Server at once by running the DQSInstaller.exe file from the command prompt. For information about doing so, see Export and Import DQS Knowledge Bases Using DQSInstaller.exe in the DQS installation guide.
In This Section
You can perform the following import and export operations:
|Export a domain in a knowledge base to a .dqs data file||Export a Domain to a .dqs File|
|Import a domain from a .dqs data file into an existing knowledge base||Import a Domain from a .dqs File|
|Export an entire knowledge base to a .dqs data file||Export a Knowledge Base to a .dqs File|
|Import an entire knowledge base to a .dqs data file||Import a Knowledge Base from a .dqs File|
|Import values from an Excel file into a domain||Import Values from an Excel File into a Domain|
|Import domains from an Excel file into a knowledge base||Import Domains from an Excel File in Knowledge Discovery|
|Import knowledge gathered during cleansing into a knowledge base||Import Cleansing Project Values into a Domain|
|Building a knowledge base by running knowledge discovery and interactively managing knowledge||Building a Knowledge Base|
|Creating a single domain, and adding knowledge to the domain.||Managing a Domain|
|Creating a composite domain, and adding knowledge to the domain.||Managing a Composite Domain|